G Guest May 16, 2006 #1 I can not figure out how to get a zero to show for values that do not meet the criteria if that is possible.
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 May 16, 2006 #2 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"
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 May 16, 2006 #3 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])
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])
