Select SQL statement

[corbinap]

I have copied this from a query but I do not know how to end or close or format the Where statement which is causing the select statement not to work. And will this work for a table in the same database?

Set rs = Currentdb.OpenRecordset("SELECT tblSourcingManagers.MGR_Code "& _
"FROM tblSourcingManagers INNER JOIN tblUsers ON tblSourcingManagers.SourcingMgrID = tblUsers.SourcingMgrID " & _
"WHERE (((tblUsers.UserID)=[CurrentUser])) OR ((([currentuser]) In ('VP1','EVP','SD')))

 

[JerryKlmns]

Previously on this channel thread705-1305736

WHERE (tblUsers.UserID='" & [CurrentUser] & "')"

Following up

WHERE (tblUsers.UserID='" & [CurrentUser] & "') OR (tblUsers.UserID In ('VP1','EVP','SD'))

you return records of UserIDs :VP1, EVP, SD and the CurrentUser if he is listed in tblUsers table. Is this what you need?


10doesch: Why the extra thread in a different forum that covers VBA on Office in general? Better stick to the dedicated Forum705