Hello Everyone.
I am trying to insert the following field into a query: Units:IIF([RTCAKitNum]=665,"mg/mL", "ng/mL")
RTCAKitNum is a number field, the commas & quotes are correct but all I get is syntax error message. If I change it to
Test:IIF(1+1=2,"yes", "no")
I also get a syntax error. I can't find any test entry that will accept the syntax.
What am I missing?
Thanks for the help. Mee
I am trying to insert the following field into a query: Units:IIF([RTCAKitNum]=665,"mg/mL", "ng/mL")
RTCAKitNum is a number field, the commas & quotes are correct but all I get is syntax error message. If I change it to
Test:IIF(1+1=2,"yes", "no")
I also get a syntax error. I can't find any test entry that will accept the syntax.
What am I missing?
Thanks for the help. Mee