Web Development



Prompt user for information in a query

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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums