force new page criteria

[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!!

 

[Klatuu]

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.

 

[Big Dog]

is it possible to NOT have the force page in effect for the first page of the
report?
--
Bill Gable

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

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!!

 

[rejoyce40]

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!!!!

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

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!!