Getting a syntax error with a select statement

Hi!

It is happening after the = equal sign:

=[forms]![frmDailyItinerary]![frmDailySubItinerary].[form]![sbfStaffing].[form]![employeeid]))

SELECT IIf(qryEmployees.Inactive,"No","Yes") AS Inactive,
qryEmployees.lastnamefirst, qryEmployees.Title,
qryEmployees.employeeid
FROM qryEmployees
WHERE (((qryEmployees.Inactive)=False)) OR
(((qryEmployees.employeeid)=[forms]![frmDailyItinerary]![frmDailySubItinerary].[form]![sbfStaffing].[form]![employeeid]))
ORDER BY qryEmployees.Inactive DESC , qryEmployees.lastnamefirst;

Not sure how to fix it.

Any ideas?

Thanks!

PaulW

Replies

• Re: Getting a syntax error with a select statement posted by Ron Paii on Thu, 19 Dec 2019