What Access version and what view when you "run the report"?
What do you see if you print the value to the debug window?
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
debug.Print "Width: " & ([TotalStudents] / 100) * (1440 * 4)
rctBar.Width = ([TotalStudents] / 100) * (1440 * 4)
End Sub
Is TotalStudents a text box in the detail section?

--
Duane Hookom
MS Access MVP


"Summing multiple fields on a form"
t.com wrote in message
...
I want to display a chart on a report. I created a query named
qryJanGraph,
which contains 2 fields [SignInDte]& the other is a calculated field name
[TotalStudents]. The expression used in the query for the calc field
[TotalStudents] was sum([Current]+[New]). I placed the 2 fields on the
report
in the Detail Section, along with a Rectangle Bar and added an Event
Procedure in OnFormat. It reads
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
rctBar.Width = ([TotalStudents] / 100) * (1440 * 4)
End Sub
Whn I run the report the Bars for all the numbers are the same...HELP