Query Help

[Aaron36]

Hi,
PLease look at this senario.

Table 1 Form(User Types In)
Low_Price High_Price Low Price High Price
595 675 595
550 600

Here is part of what I'm using

Low_Price >=varLow_Price AND High_Price <= varHigh_Price

How would I write a query that would select the unit if the user puts in 595 in the high price end?

Thanks for any help.

 

[rac2]

criterion range
<----------------------->

various target ranges
<--------->
<--------->
<--------->

So

High_Price >=varLow_Price AND High_Price <= varHigh_Price

OR

Low_Price >=varLow_Price AND High_Price <= varHigh_Price

OR

Low_Price >=varLow_Price AND Low_Price <= varHigh_Price

 

[Aaron36]

I came up with this before I read your response. What do you think?
Last Part of statement
( Low_Price>= varLow_Price) AND (varHigh_Price Between Low_Price AND High_Price OR High_Price<=varHigh_Price)