not sure if this is in the correct forum, but ill give it a go.
I am quite a beginner in access btw
what I want is this to happen:
I click on the query. A box comes up saying 'enter first range' then ok. Another box comes up saying 'enter second range' then ok and it shows me values between the first range and second range. I don't want it to be predefined, but for the user to search when they click on the query
Hope that explains all