Complex Query Command

[Anthony]

I was wondering if in access I could create a query that will show me a where
I can put for a record in a table that is less than another record in my
table but not more than another record or should I export to access and how
would I do it there.

Thanks, Anthony