Query using avg

[MOM4C1]

I need to find the average cost by vendor and can not come up with the SQL format. Can anyone help?

[June7]

This is a Totals (aggregate) query in Access. Access Help has guidelines.

In query Design view, click the Totals button (looks like Sigma). This will modify the design grid and provide aggregate functions in the Total row. Select option under each field. You need at least the Vendor ID and Cost field. GROUP BY vendor, AVG cost.