If Then statement query error

[toddgarner]

I am trying to enter the following simple code in a query

label: If ([Members]!

• )>5 then "x"
  
  where if a value in a table is greater than five the query column "label" prints an "x", however, it keeps telling me I have invalid syntax and that I might have entered an operand without an operator. Sory this is so basic, I don't normally use this for databases any chance anyone can tell me what I can do to fix this?
  
  Todd Garner
  toddgarner
  t_garner03@yahoo.com

 

[THWatson]

Todd
Have you tried
label: IIf([Members!

• >5,"x","")
  
  This assumes that you want to show nothing if the value is 5 or less.
  
  Actually, if your query is only referencing one table, Members, then you don't need the table name in the expression.
  
  
  Tom