Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report cutoff

Status
Not open for further replies.
Moxy1

Moxy1

Programmer
Aug 29, 2002
75
US
I have a report that page breaks on various stores. Each of these stores will list various products. I want to prevent a store from printing if their section of the report exceeeds 3 pages.

thoughts?
 
Sort by date Sort by votes
Can you convert pages to detail records? If so, it would be a matter of creating a similar query that groups by store and counts records. Add this query to your report's record source and join the "Store" fields. Set a filter to CountOfRecords less than your 3 page limit.

Duane
Hook'D on Access
MS Access MVP
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
444
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
436
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
486
dhookom
dhookom
monkeysee
  • Locked
  • Question
Muti Page Report 1
Replies
5
Views
426
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
445
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top