A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

sort reports onto seperate pages



 
 
Thread Tools Display Modes
  #1  
Old November 24th, 2005, 06:18 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default sort reports onto seperate pages

hi

i hae a report that is meant to look like a timetable for a course, the
course is over 3 days how do or can i get the report to print each day on
seperate pages an example of what i want is

Cancer Care course

Date 28/10/05

9am Welcome
10am What is Cancer
11am Cell Biology
12 pm Lunch
13pm Health promotion
14pm etc etc

i have a query that generates the data but it puts it all on one page so i
have the second day starting after the first

i hope someone can help

thanks

Phil
  #2  
Old November 24th, 2005, 06:44 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default sort reports onto seperate pages

"Phil" wrote in message
...
hi

i hae a report that is meant to look like a timetable for a course, the
course is over 3 days how do or can i get the report to print each day on
seperate pages an example of what i want is


Create a group on Date and, in the footer properties of each group, click on
New Page After Section

Tom Lake


  #3  
Old November 24th, 2005, 07:10 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default sort reports onto seperate pages

Phil wrote:
i hae a report that is meant to look like a timetable for a course, the
course is over 3 days how do or can i get the report to print each day on
seperate pages an example of what i want is

Cancer Care course

Date 28/10/05

9am Welcome
10am What is Cancer
11am Cell Biology
12 pm Lunch
13pm Health promotion
14pm etc etc

i have a query that generates the data but it puts it all on one page so i
have the second day starting after the first



Use the report's Sorting and Grouping window (View menu) to
group on the date field and select Yes for the group header.
Then specify the group header section's ForceNewPage
property to Before Section.

--
Marsh
MVP [MS Access]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort pages? David General Discussion 15 May 13th, 2005 11:33 PM
Selecting a report's sort order & sort fields at runtime Alp Setting Up & Running Reports 5 January 2nd, 2005 07:54 AM
Can you save individual document pages as seperate word files? kersterlm Mailmerge 3 December 16th, 2004 10:35 PM
Here's a shocker Mike Labosh General Discussion 2 October 26th, 2004 05:04 PM
Wrong sort order of report's details section dsjohn_242 Setting Up & Running Reports 6 July 12th, 2004 10:21 PM


All times are GMT +1. The time now is 03:00 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.