Anonymous asked in Computers & InternetSoftware · 9 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

  • Cyrus
    Lv 4
    9 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

Still have questions? Get your answers by asking now.