User Parameters in a query??

D

Darren

I need to set up a query that needs to promp for parameters. I just cant seem
to remeber what is to be doe in the query to cause the promp.
 
R

Rick B

What are you looking for?

If you want to see all the records where a particular field is between two
dates, for example, you would use...


Between [EnterStartDate] and [EnterStopDate]

or similar.


If you want all records where a name begins with...


Like [Enter First Part Of Name] & "*"


To find a string anywhere...

Like "*" & [Enter Partial Name] & "*"



Hope that helps,
Rick B
 
Top