Multiple records, multiple queries, one page report.

[Dragon]

I have a query that can return up to 6 records for the parameter (date).
The query is based on a table that tracks shipping for three distinct areas
of a warehouse. The report I'm working on is the daily operating report that
tracks the total amount of pounds and pieces shipped in each area and further
divided into domestic and international pound and piece totals.

Is there a way to have a particular result (sum) print in a particular place
in a single page report and list a zero when there are no records.

I use Access 2002 at home and 2003 at work, so it should work for both
versions, if possible.

Thanks,
Dragon

 

[Allen Browne]

To place the result in a particular spot on a page of its own at the end of
the report, use the Report Footer section. (If you don't see it, click the
View menu in report design.)

To sum the field called Weight, put this in the Control Source of a text
box:
=Sum([Weight])

That will show #Error if the report has no records.
To solve that, test the HasData property of the report, i.e.:
=IIf([Report].[HasData], Sum([Weight]), 0)