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

Find a number between two sets of numbers. 1

serino

serino

Programmer
Feb 13, 2003
107
0
16
US
I need some help in figuring this out. is there a way to input a number for example "51424303" and it would return a Job_ID of 1939706. Can this be done with a query and if so how?

Job_ID Range1 Range2
Table1
 
Sort by date Sort by votes
Hi,

Welcome to the new Tek-Tips.

Try this SQL where NUM is the number you referred to.

SELECT Job_ID
FROM yourTableName
WHERE Range_1<=NUM AND Range_2>=NUM
 
Upvote 0 Downvote
Skip,

Thanks! that worked for me.
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

spartansFC
  • Locked
  • Question
Display Year between 2 dates 1
Replies
1
Views
109
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Use two sorts in query 1
Replies
7
Views
63
TrekBiker
TrekBiker
serino
  • Locked
  • Question
Adding Records between two ranges 2
Replies
12
Views
145
serino
serino
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
117
JimStrand
JimStrand
mhshane
  • Locked
  • Question
Query to find keywords in description field and give count
Replies
4
Views
67
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top