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

  • Thread starter Need Help With a Compact and Repair Erro
  • Start date
N

Need Help With a Compact and Repair Erro

I can not figure out how to get a zero to show for values that do not meet
the criteria if that is possible.
 
R

Rick B

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"
 
D

Duane Hookom

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])
 
Top