Create a negative value 1

[mapman04]

I'm trying to create a new field in a query using the IIF keyword. The table holds a - or + sign to designate whether the transaction quantity is negative or positive. In the query string I have the following:

IIF(table1.signvalue = '-',-1,1)

When I generate the query, if it has the + sign, I get the 1. But if it has the - sign, it returns the *. What's the trick to get it to return a -1?

Thanks,

mapman04

 

[TheRambler]

Hi,

Just add a zero so that both results have two bytes.

IIF(table1.signvalue = '-',-1,01)