SQL - UPDATE Query

[springboardjg]

Hi

I have two tables named [Sites and Weekly Averages] and [Average Groupings].

In both tables there is a field named [Site Serial] with unique values, but they are not related as yet. I want to update a field in [Sites and Weekly Average] with the values from a field in [Average Groupings] where the [Site Serial] values match.



I am new to SQL but I think this would be an UPDATE query? Can someone help me with constructing a query.

Many thanks

James

[Rixxe]

Think this might be useful for you:

http://www.techonthenet.com/access/queries/update2.php

Have a go , if you get stuck come back, and im sure someone will be able to help you out.

Good Luck.