Make record on report invisible

D

D_K

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
 
R

Rick B

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