Using the AVERAGE Function

[Phil M.]

I have two tables: Items and Transactions.

Items has the Item name, description, location, etc.

Transactions has purchases of the items. There is a field for amount paid.

I want to make a Query that lists the ITEMS, and the average of Amount Paid.
I cannot seem to get this to work! Can someone give me the steps??

 

[Guest]

You may be better suited using a report to create the
averging. The fields can be brought into the report either
in detail and a subtotal created for the average of the
detailed lines. The detail can be suppressed so that the
report shows only the subtotal averages. It is a bit more
work but will give you the answer you desire.

Allan Koodray
AKA Business Solutions
(e-mail address removed)

 

[Guest]

Link the tables by item id. Pull down the description
field from Items and the paid field from Transactions,
then go into the View menu and select Totals. Leave the
Desc field at 'Group By' and change the paid field to
AVG. If this is what you have already done, you'll have
to post more details -- no reason this wouldn't work
unless you have a problem with the link between the two
tables...

--Wendy