Report excluding empty fields

[Fidelachius]

I have tried a few ways to accomplish this but it hasnt ended the way I would like so im hoping someone can help.

I have a hourly report I need to run and one of the records will always be filled with a name of the employee. I need to hardkey some data in every day and instead of changing who is there that day I would like to be able to enter in, for example, sales data in a seperate record and when I go to create the report it will exclude any employee names that have 0 sales data or a blank record. so the table would be something like:


Employee.....Sales....
John.............0
Steve............__
Mathew..........1

So when I run the report it will only pull Mathew's name and sales information and leave John and Steve off the report.

Thank you in advance!

 

[Pat Hartman]

Use Criteria in the Report's RecordSource query to select the rows you want.

Select ...
From ...
Where SalesAmt <> 0 AND SalesAmt Is Not Null;

 

[Fidelachius]

Perfect thank you!