display properties between a certain price

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I display all properties with a price between £75000 and £95000
 
Create a query based on the table with the prices.

Drop down all the fields that you want to see from the table to the columns
below.

In the criteria row for the field having the prices, put the following:

Between 75000 And 95000
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Update Query Returning Message Re Single Row Update 1
Average certain records? 5
Raspberry Pi 2 energy monitor with Inky pHAT (ePaper/eInk/EPD). 2
Help creating query in Access or should I be using a formula in Ex 3
Access Queries Look Up 5
Stock prices differences 2
Combining Multiple Query Results in 1 Query 1
144hz via DVI to Display port 8

Back
Top