query criterias

[uapak90]

this is probably a simple question, but I really don't know access that well. I have a query which has employee names, employee id, and a couple more fields. When i want to run a query, i want the query to ask me whose name to pull up so i can enter a name and it will show me everythign about that individual. How do i set that up in the criteria? Is that the expression that deals with "!". If someone can tell me how to write the expression, i will be very thankful.

 

[PHV]

How is supposed to be launched the query ?

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

 

[uapak90]

i don't exactly know what you just said, but basically, when i run the query, i want a pop up box that tells me to input an employee name.

 

[PHV]

In the criteria cell of the employee name column in the query grid:
= [whose name to pull up ?]

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

 

[uapak90]

thanks so much! lol that was easier than i thought haha.