I have a table using a logical. When I want to run a query to translate one value (-01) as 'Active', with the other value (0) as 'Inactive', I have tried, but get errors. Could someone tell me the proper syntax for the field in a QBE? I should be able to put this into a Union query.

tblVendor.Active (table, field)

e.g. Active: IIF([Active]=01, 'Active','Inactive')

Thanks!

- John

First you said that active is -01 but your IIF statement as 01. Which is it?

Second, is it a number or text or boolean? Respectively,

Active: IIF([Active]=-1,"Active", "Inactive")
Active: IIF([Active]="-01","Active", "Inactive")
Active: IIF([Active]=TRUE,"Active", "Inactive")

In Access booleans, -1 is TRUE and 0 is FALSE.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division