Discuss "Having real trouble with update queries" in the Microsoft Access forum.

I cannot seem to figure out how to do this:

I have a table calls that is a sub of contacts

I query calls and get the last 10 of what ever contact

I Then Average them. I do this with 2 queries

At last I am trying to make an update query that takes the value found in the average and update a field in the table contacts that was made custom for this function.

I understand that this is not "conventional design" and goes against rules but there is method to my madness. Someone please help because being able to do this is one of the main reasons I want to develop my contact management system (that other types you can purchase do not seem to accomodate)

I am getting errors that say you are not including contactid in the aggregate function

One last thing. I am just starting out and am not familiar with SQL statements. Please address this from a graphical interface standpoint

1. What are your table and field names?

2. What is the SQL of the query you are trying to use?

Bob Larson, Access MVP