Search results
-
M
Access in the day job
Hello Everyone. I'm a Cell Biologist by day. Several years ago I was given a data analysis problem by my boss that couldn't be solved with a simple excel file. So I had to quickly become the local expert in relational database design and Access (Shout out to the "... For Dummies" books!) I've...- Mee
- Thread
- Replies: 4
- Forum: Introduce Yourself
-
M
My version of access does not like IIF.
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...