Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating Queries in Access

Status
Not open for further replies.
jmk2z

jmk2z

Programmer
Oct 29, 2002
18
US
How does one create a query in Access that uses as criteria a value inputed by the user at the time the query is run?
 
Sort by date Sort by votes
When you are in design mode, go to the column that lists the field you are basing your user input on, and in the criteria row enter:
Code: 
[Enter Value]
Where "Enter Value" is whatever text you want to prompt the user with.

Dan.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Use 2 columns in Detail Section of report 1
Replies
8
Views
833
TrekBiker
TrekBiker
D
  • Locked
  • Question
How can i have more than 1 line in the body of an email
Replies
2
Views
454
Andrzejek
Andrzejek
BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
946
bs6600
bs6600
Cpreston
  • Locked
  • Question
Trim Multiple items in one column
Replies
2
Views
390
Andrzejek
Andrzejek
Andyri
  • Locked
  • Question
Limits in Excel 2
Replies
7
Views
578
Andyri
Andyri

Part and Inventory Search

Sponsor

Back
Top