I have a query written that will search 7 different fields for the same name and then display all the records that match that name. However I have multiple employees that will need to run this query. Is there anyway I can have the query ask the user for their name or give them a drop down box and have them select their name?
here is my code so far:
SELECT Details.[Event-Name], Details.[Event-Date-Start], Details.[Event-Start-Time], Details.[Event-End-Time], Details.[Major-Topics], *
FROM Details
WHERE ((([Assigned-ES] & [Presenter-1] & [Presenter-2] & [Presenter-3] & [Presenter-4] & [Presenter-5] & [Presenter-6]) Like ‘*User Name*’));
