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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting records 0
Report for Max, Ave & Detail Record for Highest Sale Price by Cate 1
Calculating unduplicated NET totals in reports 1
Parameter Report with a Chart in the footer 1
In an Access report, how can I count specific records in a group? 1
set sub report height 0
Invisible field and shrinking report 1
Checkbox on report - how to make it disappear? 1

Back
Top