HOW TO DISPLAY ZERO IN COUNT QUERY 1

[pelagic]

Hi All,
This is what I have in the table1
BEFORE AFTER
100 105
200 250
50 100
300 200
when I run and count query, I created another column named
RESULT. How would I display in RESULT column a ZERO when BEFORE is smaller than AFTER? The output might look like this:
RESULT
0
0
0
1
Any hint will help.
Thanks in advance
regards,

 

[jrbarnett]

Go into the query design and put

Result: Iif(Before<After,0,1)

in a new column.

John