|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 3rd, 2010, 10:57 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Charts on a Report
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 
|
| Thread Tools | |
| Display Modes | |
|
|
Threaded Mode