User Parameters in a query??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In a query (in criteria) how do I promp for a "substring"? 1
Parameter Query Won't Run 0
Replace chars 3
Replacing Chars 7
Modify Parameter Query 1
Access: How can I create a query with set parameter 3
Parameter Queries in Crosstab Query 2
Sources for query parameters 10

Back
Top