Page break by groups of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that is sorted by date. Is there a way to have the query automatically page break after a change in the date. In other words the result of the query is 15 records for 4/10/04, 25 for 4/11/04 etc. I want each "date" data to print on a seperate page. Any suggestions would be greater appreciated! Thanks
 
Teresa said:
I failed to mention that I'm running a report that is driven off of a query. Thanks



----- Teresa wrote: -----

I have a query that is sorted by date. Is there a way to have the query
Click to expand...
automatically page break after a change in the date. In other words the result of the
query is 15 records for 4/10/04, 25 for 4/11/04 etc. I want each "date" data to print
on a seperate page. Any suggestions would be greater appreciated! Thanks

Hi Teresa,

In an Access report based on your query,
click on the "Sorting and Grouping" icon.

In the "Field/Expression" column,
select your date field.

Change "Group Footer" to Yes.

Close the dialog box.

In the Properties of your new footer
(probably "GroupFooter0"),
set "Force New Page" to
"After Section"

Please respond back if I have misunderstood
or was not clear about something.

Good luck,

Gary Walter

BTW don't forget you might get *more expert*
help with reports in

microsoft.public.access.reports
 
Back
Top