Calculating whether a value in one table is between a hi/lo value from another t

[Greg]

I'm trying to find if a value from a field in one table
falls between two values from two fields in a second table.
The problem here is I have a select query set-up with those
two tables but when I run it the recordset never completely
calculates total number of records. I know that the query
is set-up according to example. There are over 500K records
in the table being queried.

Is anyone willing to take a crack at this?

 

[Rebecca Riordan]

I'd try building two additional queries, both of them based on the "look up"
table -- select only the field you're checking and the field(s) you're
relating to the primary table, sort one ascending and the other one
descending, and set the query to return only the Top 1 record (you do this
in the property window).

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...