Make record on report invisible

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Lets say I have two fields in the detail section of my report: Sales, and
Hours. I then have another field [Sales]/[Hours] which gives me the sales per
hour.

Is there a way to make the ENTIRE RECORD invisible if the sales per hour is
< 100 for example? Or better yet, can I delete this record from the report so
that it doesn not leave a blank space on the report?

Thanks,

Dan
 
Yes, add that field yo your query and set the criteria so that records below
your criteria are not included.
 
Back
Top