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!
 
Back
Top