Question Locked

Prompt user for information in a query

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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*'));

2 replies

This discussion is closed to new replies.