View Full Version : Grouping Records In Reports


madrav72
01-03-2006, 04:19 AM
I have some records that should display on the same page i.e. the report shows entries for a appointment for the current week.

so for isntance this weeks entry might have entries for one intervieewer having an interview on the 3rd and 4th and 5th.

the trouble with the report appears that for each of the entries mentinoed a seperate page is being generated - which doesnt seem right how can i overcome this issue?

Hayley Baxter
01-03-2006, 05:31 AM
Go into design view for the report > sorting and Grouping.

Field / Expression is Interview date to sort by interview date.
Group on: Week
Keep Together: Whole Group

The above should group weekly interviews together. I think this is what you are aiming for, let me know if I have mis-understood your question.

Hay

madrav72
01-03-2006, 06:04 AM
Many Thanks Hayley!!! It did the trick