Query selecting between 2 values
machaons
-
yg_be Posted messages 23437 Registration date Status Contributor Last intervention -
yg_be Posted messages 23437 Registration date Status Contributor Last intervention -
In Access 2003, I’d like to select various data that are located between two numbers, a minimum and a maximum. In my current database, the field in question is text, e.g.: "17 to 23". Each time I want to perform a selection, I supply a number, and the query should find all records whose values are between these two values (minimum and maximum included).
Is this possible or should I modify the database to facilitate the query? How to write the query?
Is this possible or should I modify the database to facilitate the query? How to write the query?
1 answer
yg_be
Posted messages
23437
Registration date
Status
Contributor
Last intervention
Ambassadeur
1 588
If I understand correctly, you have a field in a table in an Access database.
what is the type of that field?
can you give an example of what that field contains for several records in your table?
what happens next? have you already written a query, or not?
i suppose that, when you write "chiffre", you mean reading "number".
you want to give a number to the query, and then you write "between these two values". which two values?
feel free to use examples to explain yourself.
what is the type of that field?
can you give an example of what that field contains for several records in your table?
what happens next? have you already written a query, or not?
i suppose that, when you write "chiffre", you mean reading "number".
you want to give a number to the query, and then you write "between these two values". which two values?
feel free to use examples to explain yourself.