Syntax Error

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

I am using Access 2002. In a text box I have added:
IIf([Tuition Award Term1]="Academic Year",[Tuition
Amount1], " ") and I receive the message syntax error
(comma) in a query expression.

Can anyone tell me what I am doing wrong?
 
you entered the IIf function in the textbox's RecordSource property? did you
preface the IIf function with and = sign?
 
Tina,
No, I didn't. I'll try it. Thanks.
Tracy
-----Original Message-----
you entered the IIf function in the textbox's RecordSource property? did you
preface the IIf function with and = sign?


I am using Access 2002. In a text box I have added:
IIf([Tuition Award Term1]="Academic Year",[Tuition
Amount1], " ") and I receive the message syntax error
(comma) in a query expression.

Can anyone tell me what I am doing wrong?
Click to expand...


.
Click to expand...
 
Back
Top