Operand without operator or

[burrina]

Trying desperately to enter criteria into query. Whats wrong with my syntax?
chk:If ([PeriodTypeID]) = "d" And ([PeriodFreq]) = "1" [txtentered] = EventStart + 1 ElseIf ([PeriodTypeID]) = "ww" And ([PeriodFreq]) = "1" Then txtentered = [EventStart] + 7 ElseIf ([PeriodTypeID]) = "q" And ([PeriodFreq]) = "1" Then txtentered = [EventStart] + 90

[pbaldy]

If/Then code is only valid in VBA. In a query, you can use the IIf() function. You can either nest them to do what you're doing or use the Switch() function.

[burrina]

ok, thanks. Too complex for me.. Thanks Anyway!