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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Between in parameter query 1

Status
Not open for further replies.
Cloonalt

Cloonalt

Programmer
Jan 4, 2003
354
US
How can I set up a parameter in a query that lets me find a range of numbers.

One field - ID - and I want to prompt for a range of numbers.

Thanks!
 
Sort by date Sort by votes
in the criteria cell of the appropriate field, type this:

Between [Enter Beginning Number] and [Enter Ending Number]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
497
dhookom
dhookom
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
504
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
568
dhookom
dhookom
RonMcIntire
  • Locked
  • Question
Adding variables to a control in a footer 1
Replies
4
Views
286
sxschech
sxschech
PrimoSteve
  • Locked
  • Question
Print Report from a Subform (Tab form) in a Main Form
Replies
1
Views
195
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top