Query by Name

[Brian62]

When the query runs I would like to filter by name.
Example when the query runs. Opens up with : Enter Name:
I would enter the name then the query will pull all the information for that name.

[dcrake]

Have you tried setting parameters to your query yet?

In the condition row under your name field enter

=[Enter Name:]

David

[Brian62]

Is there a way to pull any part of the name by first name or last name in a single column?

[Brian62]

I figured a way to pull the information. I used: Like "*" & [Enter Name: First or Last] & "*"