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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group By, Max & Last 2
show balance in a query 1
Min/Max Dates and Group By 2
Query to return complete record with max cost within grouping... 6
Time Calculated minus breaks & lunch 2
Limit data in field to within 90 days of another field... 4
Count by short date and group by agent name 6
Sum, group, date 2

Back
Top