Price Range

  • Thread starter Thread starter Chris Grant
  • Start date Start date
C

Chris Grant

Hi,
I have set up a database about the sale of houses, and i
need to set up a query which includes all of the homes
between two prices such as £100,000 and £120,000. Could
you please tell me how to do this,
Thanks a lot
 
You will want to use the between function in the criteria
row in the field where the price of the home is stored.
You would type directly into the criteria row of that
field: "between 99999 and 120001" (without the quotes of
course).
 
Back
Top