Hi John,
Correct...my report is showing one page for each record.
Report 'Record Scource' = IncidentReportQuery
SELECT IncidentReport.IRID, IncidentReport.Date, Format([Date],"m") AS Mth,
IncidentReport.[Slip/Trip - food stuff on floor], IncidentReport.[Slip/Trip -
beverage on floor], IncidentReport.[Slip/Trip - liquid (other) on floor],
IncidentReport.[Slip/Trip - rainwater on floor], IncidentReport.[Slip/Trip -
other foreign object on floor], IncidentReport.[Slip/Trip - uneven floor],
IncidentReport.[Slip/Trip - no apparent reason], IncidentReport.[Slip/Trip -
wet weather mat], IncidentReport.[Slip/Trip - other],
IncidentReport.[Illness/Fainting], IncidentReport.Theft,
IncidentReport.Vehicles, IncidentReport.[Low height fall (less than 2m
high)], IncidentReport.[High height fall (2m high or higher)],
IncidentReport.[Caught in - door], IncidentReport.[Caught in - machinery],
IncidentReport.[Caught in - lift], IncidentReport.[Injured on - escalator],
IncidentReport.[Injured on - moving walkway], IncidentReport.[Property/Stock
damage - tenant], IncidentReport.[Property damage - other],
IncidentReport.[Walked into door/window/object], IncidentReport.[Serious
Criminal Activity], IncidentReport.[Struck by object], IncidentReport.Other,
IncidentReport.[Incident Description]
FROM IncidentReport;
Have tried Grouping...no luck.
John W. Vinson said:
I'm using the Abs Function in a report to calculate the total occurence of
specific incidents per month over a calender year....=Sum(Abs([MyField
Name]=-1 And [Mth]="7")).
All works well but....the report returns the same number of pages as there
are records in my query.
What the!!!
Any suggestion...
The Sum expression has nothing whatsoever to do with the number of pages in
the report.
Please post the Recordsource property of the report (the SQL of it if it's a
query). My guess is that your report is... showing one page for each record.
Do you have any sorting/grouping defined on the report?