IIf Statement giving error

[melissafvoelker]

SELECT Conversion.[Asset Class], iif([asset class]<4000, "1", "2")
FROM Conversion;

 

[pdx_man]

What is the error you are getting?

Works fine for me. It will automatically assign a field name to the expression ...

What version of Access?

 

[melissafvoelker]

Table Issue?

Hi,
Thanks! I think that I was trying to add data to a table that was "locked" is that possible? because when I tried in on another table, it worked fine.