Getting a syntax error with a select statement

Giganews Newsgroups
Subject: Getting a syntax error with a select statement
Posted by:  PW (…@noemailaddress.com)
Date: Wed, 18 Dec 2019

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