Group by Name

[rgreene]

Hi all,

I have a database that I created that is for our social workers. They enter their contact with their clients in this and then at the end of the month they need to print a couple reports out and mail them to the state. I have the report but I need help grouping the output. My report is set up so the Social Worker will enter that starting date, the ending date and the Social Workers name. When the report runs I might have 2 entries from one client and 7 entries from another client all run together. What I would like is for the 2 entries from the 1 client to print on one page and the 7 entries fron the next client to print on the next page(s), all entrries for the third client on a third page, and so on?

Any suggestions?

Thanks in advance,
Rick

 

[Rich]

Add a group level for the client

 

[rgreene]

What does that mean? I'm not an access guru.

 

[ipr1]

Hi - In addition to grouping by client, select under the group properties that you want to keep each group on its own page (the group properties are in the grouping/sorting tool and it is the last entry ("keep together").

Hope this helps.

 

[rgreene]

How do I group by client?