How to look up for multiple records

[thembela]

I have created a database with all our SAP users on Ms access.In the Username field of my query, in the Criteria text box, i tried to put in about 10 users(using their username) one by one.And it works fine, but it's time consuming.I then pasted the 10 usernames all at once in the criteria text.But it doesn't want to work.How can i make it work.

Please help...

 

[PHV]

Use the IN operator:
IN ('username1','username2',...,'username10')

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886