creteria using other fields

[Guest]

I have a table with one field with many unique numbers: 1000 for example.

I have created two other fields that add and subtract 10 digits giving me a
value of
900 in one field and 1010 in the other field.

I want to pull all the records from another table that are between 900 and
1010.

There are many such numbers in the original table that I want to
automatically perform this operation on.

 

[John Spencer]

Perhaps you can use a non-equi join such as the one below. You cannot build
this type of query in the query grid, but must do so in the SQL (text) window.
Generically, this would look like.

SELECT T.*
, N.[MinimumNumberField]
, N.[MaximumNumberField]
FROM [TargetTable] as T INNER JOIN [NumberTable] As N