Full Version: Dumb Question
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
Redhawk362
I've sorted my report on a YesNo variable named Recurs.

I would like all the records with Recurs set to False to print first and then page break and print the records with Recurs set to True.

Haven't been able to figure out what to set in Report design.

The report prints but all the records print w/o the page break occurring.

I'm a hobbyist so any help would be appreciated.

Thanking you in advance,

Jerry
MikeLyons
QUOTE (Redhawk362 @ Sep 12 2011, 09:45 AM) *
I've sorted my report on a YesNo variable named Recurs.

I would like all the records with Recurs set to False to print first and then page break and print the records with Recurs set to True.

Haven't been able to figure out what to set in Report design.

The report prints but all the records print w/o the page break occurring.


I'd use the Sorting and Grouping for the report to actually group on your boolean (True/False) value. You can then set it to have a page break on the group footer.

Mike
Redhawk362
Your suggestion solved the issue.

Thanks again Mike.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.