in a query return a zero for values that do not meet criteria

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

Guest

I can not figure out how to get a zero to show for values that do not meet
the criteria if that is possible.
 
If they don't meet the criteria, then the record would not be selected.

Please give us an example of what you are trying to do.

--
Rick B



"Need Help With a Compact and Repair Erro"
 
A simple example of a few records would really help us. Without that, I can
only guess that you might be able to use IIf().

NewColumn: IIf([SomeField]<10, 0, [SomeField])
 
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

Show Duplicate records only once 3
Query that returns values greater than zero 2
how to find records based on three sets of criteria 2
need help with expression 3
IPad remote 10
Access Query to show records that do NOT meet join criteria 1
Return Zero Instead of Null from a Query 2
AND on 2 fields along with other criteria in query 2

Back
Top