Changing numbers in a query

[Board2Death]

I have a field named Within in a query that contains integer values.

I would like to create another field Tally in the query where:

if Within is less than or equal to 0, Tally = -1 [/color blue]

Otherwise Tally = 0 [/color blue]

I am stumped. Any ideas would be greatly appreciated. TIA...

 

[PHV]

In the query grid:
Tally: IIf([Within]<=0, -1, 0)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[earthandfire]

Without seeing your query this is a little difficult, however you could try something like:

SELECT Within, IIf(Within <=0,-1,0) AS Tally FROM YourTable

Hope this helps

 

[Board2Death]

Thanks...