Blank records in a report

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

Guest

I have a employee report that shows actual hrs and projected hrs for each
month. If the values are blank or zero for each month, I don't want to show
the employee's name on the report.

For example

Jun Actual Jul Actual Aug Projected
Sept Projected
Ruth Pierce 0 0 0
0
Gary Weber 12 24 7
55
Sara Hoffa 55 10 25
36


In this instance, I'd only want Gary and Sara's info to appear on my report.

How do I do this?

Thanks
 
Change the query (upon which your repost is based) to exclude any records
with zero values.
 
I just answered a very similar question in the query newsgroup yesterday...


---------------------------------
In the criteria put...

<>0

for each field.

Placing this on the same line for each will create an AND statement.
Placing them on separate lines will create an OR statement. Since you want
to show any record where column 1 is not zero OR column 2 is not
zero OR column 3 is not zero, you'd want these three criteria on
separate lines at the bottom of the query design view.
 
Back
Top