greater than or less than an equation

[lonetree]

I am interested in help in two aspects of the question: Can and how to set up query(s) to find records that satisfy an inequality of an equation? Can SQL or the graphic query interface be used to find records that containing two variables which fall to one side or the other of an equation of a line.

If so can anyone give me hints or help on how such work can be done?

 

[rafe]

You sure can do. I use compound expressions like ...

WHERE Type>=20 AND Type<=29 AND Status=0

in my queries. The easy way is to go to the Access Query Builder (choose your table) drag the fields you want down to the grid &amp; place the inequality expression into the &quot;Criteria&quot; for that field. Like...

>20 AND <29

Notice that in this case the &quot;Type&quot; has been omitted because it's assumed by the query builder.

Anyway... this kind of thing is heavily documented in help.