Recent content by Mee

  1. M

    My version of access does not like IIF.

    I take that back. I see this What does this mean?
  2. M

    My version of access does not like IIF.

    I did as you suggested. ?IIF(1+1=... returned the correct answer, no errors here. In the VBA editor, when I click tools, References is greyed out; I can't select it. Is this the source of all the problems and how do I fix it?
  3. M

    My version of access does not like IIF.

    It's a company computer so I'll have to get our IT to do it. The RTCAKitNum field is coming from another query. The point of the query I'm trying to build is to join the query data with data from another table.
  4. M

    My version of access does not like IIF.

    Yes. I've triple checked that.
  5. M

    My version of access does not like IIF.

    Interesting idea but not it. I tested IIF, Iif, IiF, if, IF, If. One curious thing; when I switched from IIF to IF, I got the same syntax error. It didn't switch to "bad command" or some error like that. I also tried swapping out the commas for ; . or |. Didn't like those either, although...
  6. M

    My version of access does not like IIF.

    You're right, Left doesn't work either. Without extensive testing, I assume the others are broken as well.
  7. M

    My version of access does not like IIF.

    Ok, you have exceeded my understanding already. Is English a stupid answer?
  8. M

    My version of access does not like IIF.

    We are using Office 365 enterprise -Mee
  9. 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...
  10. 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...
Top Bottom