Entering correct Criteria in a query design field

S

shepherdess

I have a switchboard form designed; I have the switch to select etween two
dates and print the appropriate report; no sweat. However, I need to set a
second criterion that will select the proper employee and sort only his or
her production data for the date range that has been selected. What is the
statement i should use to set the criterion to select a particular employee
by his or her [Time Card ID]? Once I have the correct statement I can utilize
that for my other switches that select CSRs and Sales reps data in the same
way.

Thank you so much in advance. This is the last bit of info I need to finish
the database I am working on.
 
R

richard

If you want an exact match on the Time Card ID field then enter in the
criteria in the query
=[Employee Time Card ID] (or any other wording you want to get the repsonse
from the user)
this will give a box asking for the Parameter value 'Employee Time Card ID'
if you want to have the user enter just a portion the emplyee time card ID
then
 
R

richard

Missed the end of the last post

for the variable repsonse from the user then use

Like [Employee Time Card ID] & "*"

this will allow the user to enter just '1' to get all the records starting
with 1

hope this helps

Richard
 
Top