Separate Pages By Unique Field

[DrPat]

Hello Friends,

I am a Dr. an amateur DB programmer and would like help on the following situation.

I have a DB with all my patients and (among other things) all their referral source.

I would like to print a status report of all my patients, grouped by the referral source, and fax them to the appropriate offices. Easily done with the report wizard.

What I need to know is, how do I create one report, but force a new page for each referral source?

Thanks.

(By the way, I'm an American but somehow I wound up here. I have to say thanks and congrats on your new prince, if you're the type that cares)

 

[Mihail]

Force new page property in the Property sheet of report (Format tab)

 

[DrPat]

Thanks Mihail, But when I do force new page in the detail section of the report, it gives me a new page for every record (every patient). I would like all the patients from one referral source on the same page so it can be printed and faxed. I'll give you an idea of what I'd like to see.

July 29, 2013
To: My Best Referrer
Fax: 888-1111
Patient Date of Exam Date of Discharge Date of Next Visit
Willis, Bruce 9/20/12 1/21/13 7/31/13
Stallone, Sylvester 10/15/12 2/20/13 8/15/13
Wayne, John 12/1/12 4/1/13 9/20/13

----------------------- Page Break -------------------------------------------

July 29, 2013
To: My Second Best Referrer
Fax: 999-0000
Patient Date of Exam Date of Discharge Date of Next Visit
Chan, Jackie 10/31/12 2/11/13 8/15/13
Depp, Johnny 11/5/12 3/1/13 8/1/13
Snipes, Wesley 1/1/13 5/3/13 10/5/13

 

[DrPat]

That did it! Thanks so much