Inserting a Page Break to Show Week by Week Pages

[ChrisSedgwick]

Hi,

I've created a report based on a query that shows me the jobs that have been added to tblJobs between two selected dates.

The report works fine and displays all the information I need, however other than being sorted by day of the week i.e. Monday, Tuesday, Wednesday etc. The records just run on one after another.

I want to create a page break, so that a full week is shown on a single page before then forcing a new page when it moves in to the next week.

Is there a way I can do this? I hope I've explained this correctly.

Thanks,
Chris

 

[JHB]

Then you need a group (band) for the week number.

 

[ChrisSedgwick]

Thanks for your response.

I'm not fully sure I understand your answer. Will this include me adding a week number field to the table.

At present the query uses the input date from the tblJobs then sorts them by date. I've then included a format to show days of the week rather than the unique date.

All I want to now do is have a new page for each week. So it will show Monday - Friday on the furst page and then Monday-Friday on the next and so on.

Thanks

 

[spikepl]

Access is like a baby - you have to feed it the information and guide it. If you want to group on weeks in a report you have to give it the information. Add a weeknumber to the query. One of the date functions can give you a week number; http://www.techonthenet.com/access/functions/

 

[ChrisSedgwick]

Hi,

I've tried to use this in my query in a new field which Ive set up using the expression builder.
DatePart (ww,[Jobs Inputted Date],2,)

The query returns with the fields all showing #Func!

Any ideas?

 

[spikepl]

Yes. Read the doc for the function, use one of the examples there. Follow it to the letter (and "character/sign"), because you have not done so. Programming languages have 0 tolerance for sloppiness and 0 capability for guessing what you actually want, which is why the syntax must be adhered to 100 %.

 

[ChrisSedgwick]

Ok, I've done this now. So the query now shows the week number when I run it.

How to I now incorporate this in my report so that the report only show week by week pages, whilst still grouping by weekday also (already in place)

 

[ChrisSedgwick]

I think I've now managed to sort the report out and it now lists each week page by page.

My only issue now is that some of the information doesn't show. I'm now sure If I've put the grouping in the correct place.

I've placed the grouping of the expression just below the page header. Is this correct?

 

[JHB]

Post you database with some sample data, + name of the report in which you've the problem.
Also info which information doesn't show!