Using "if" statement in a query...

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I would have sworn that I had used an "if" statement in a query before, but
I'm having problems with it now. This is the equation I'm using in the
field section for data (by the way, [prospect] is a checkmark field):

if ([prospect] = true, "This person is a prospect", "Not a prospect")

I'm getting an error message that says: "Undefined function "if" in
expression." What am I doing wrong? Thanks!
 
Doh! Never mind. I realized I just forgot the extra "i" in "iif"

Sorry for the post!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Query Help! 7
Either or in query 1
Archiving related tables ????? 1
IF equation will not calculate 1
Find the top two children 1
Query Functions 3
update subquery 1
Append Query 4

Back
Top