force new page criteria

  • Thread starter Thread starter rejoyce40
  • Start date Start date
R

rejoyce40

My report shows monthly meeting information [date, event, location, time,
etc] grouped/sorted by date, then time. How can I get the report to start a
new page for each week, beginning on Mondays? I just have the table of
information and the report, no query.
Thanks!!
 
Create a query from your table and add a calculate field.

TheMonday: DateAdd("d", vbmonday - DatePart("w", [MeetDate]), [MeetDate])

That will create a date field that is the Monday of the week the date is in.
Then add a Group to your sorting an grouping for TheMonday. Set the Force
New Page property in the Group header.
 
is it possible to NOT have the force page in effect for the first page of the
report?
--
Bill Gable


Klatuu said:
Create a query from your table and add a calculate field.

TheMonday: DateAdd("d", vbmonday - DatePart("w", [MeetDate]), [MeetDate])

That will create a date field that is the Monday of the week the date is in.
Then add a Group to your sorting an grouping for TheMonday. Set the Force
New Page property in the Group header.
--
Dave Hargis, Microsoft Access MVP


rejoyce40 said:
My report shows monthly meeting information [date, event, location, time,
etc] grouped/sorted by date, then time. How can I get the report to start a
new page for each week, beginning on Mondays? I just have the table of
information and the report, no query.
Thanks!!
Click to expand...
Click to expand...
 
Mr. Hargis,

Please forgive my ignorance - I know just enough about Access to be dangerous!

I tried to follow what you suggested and unfortunately I was unable to get
it to work.

Maybe if I provide some more info, it will help...

My month table

ID Day Start Time Event Contact Location
15 12/19/2007 4:15:00 PM MtgA Joe S Rm1
16 12/20/2007 8:00:00 AM MtgB Pat J Rm2
17 12/3/2007 10:00:00 AM MtgC Len M Mtg Rm 3
18 12/3/2007 1:00:00 PM Interviews Clay D Mtg Rm 3

The report will then show ...

Event/Meeting Contact Location Time
3 Monday
MtgC.................Len M.................Mtg Rm 3............10:00AM

20 Thursday
MtgB.................Pat
J...................Rm2.....................8:00AM


I need to have the report to show a week per page, beginning with Monday.

If you could please help me to understand what I am not doing correctly, I
certainly would appreciate it!!

Thanks so much!!!!



Klatuu said:
Create a query from your table and add a calculate field.

TheMonday: DateAdd("d", vbmonday - DatePart("w", [MeetDate]), [MeetDate])

That will create a date field that is the Monday of the week the date is in.
Then add a Group to your sorting an grouping for TheMonday. Set the Force
New Page property in the Group header.
--
Dave Hargis, Microsoft Access MVP


rejoyce40 said:
My report shows monthly meeting information [date, event, location, time,
etc] grouped/sorted by date, then time. How can I get the report to start a
new page for each week, beginning on Mondays? I just have the table of
information and the report, no query.
Thanks!!
Click to expand...
Click to expand...
 
Back
Top