Access Reports

[vlwilburn]

In my access database, I created a check request report which recognizes a
query. How do I get the report to go to the next record within a persons
record if there are more than one expenses. It wants to print up a separate
report for each expense which gives the report total an error, i.e. County
Club Dues $260.00, Parking $48.00 are on two separate lines, however, it
gives me a report for Country Club Dues and a separate half report for
Parking. Is there a way in either query or the report to force it to go to
the next record?

 

[Boyd Trimmell aka Hi Tech Coach via AccessMonster.]

If you mean a new page for each expense category, then use a group header and
set the force new page to before section.

You can use the group footer to get a total for each expense category