Need help date and name problem

[bacardi451]

Hi,
I have a form that has the following fields: Date, Name and Score
I am trying to build a query using the date and name field.
I have figured out the criteria for the date which is Between [start date] and [end date] but cant figure out the name criteria.

I just want the person to be able to lookup there score from a start date to an end date without them getting everyone elses information.


Thanks in Advance
Al Rivera

 

[pbaldy]

Looks like you're using a prompted parameter query (it asks for the dates when it runs)? Just put [Enter name] in the criteria for the name field, and it will try to match whatever is entered. If you want the user to be able to enter a partial name, try

Like [Enter name] & "*"

in the criteria