Anonymous
Anonymous asked in Computers & InternetSoftware · 8 years ago

Microsoft Access Query Help Please?

Create a query that shows the average price and number of homes sold by style of property. Sort the query by the average selling price in ascending order.

1 Answer

Relevance
  • Cyrus
    Lv 4
    8 years ago
    Favorite Answer

    in your query, drag price, homeID, and style to your list of fields

    right-click to select "Show totals"

    Put Group By under totals for style

    Put Count under homeID

    Put AVG under price

    Source(s): http://acsdb.com
Still have questions? Get your answers by asking now.