How do I eliminate rows of all zeros from a query/report

  • Thread starter Thread starter Lindsay
  • Start date Start date
Do you mean every field in the row is ZERO?

You would have to test with Not zero for each field.

If you mean something else, like the sum of the fields is zero, or a specific
field has only zeroes in it, or some other variation then please post back with
an example of the data you want eliminated?

If you don't understand how to apply criteria to a query, then post back and say
that.
 

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

query export wont allow a zero value? 2
Eliminate 0 value in crosstab 5
errors in report 1
Can't create a report from my query in Access 1
cross tab query fill with zero 3
Multiple Queries to Multiple Reports 1
Force text field to numeric field? 2
Eliminating Duplicates from a Query Access 2007 6

Back
Top