Update Queries and modifying records in a table

[techsupport3977]

I have a query that has fields qProduct, qSize, and qAmount.

I have a table that has fields tProduct, tSize, and tAmount.

The query will crank and depending on the situation will produce different numbers in the size and amount field, but the product will stay the same. I need to update the product which only is listed once in the table with the result from the query.

Example:

Table

tProduct tSize tAmount
Ball 20" 500
Scooter Large 25
Bat Medium 300

Query

qProduct qSize qAmount
Ball 20" 350
Bat Large 200


After Update the Table should look like this:

Table

tProduct tSize tAmount
Ball 20" 350
Scooter Large 25
Bat Large 200

How do I set the Update Query in Access to understand this?

 

[KenReay]

Hi

UPDATE tblProduct INNER JOIN tQueryBase ON tblProduct.tProduct = tQueryBase.qProduct SET tblProduct.tSize = [tQueryBase].[qSize], tblProduct.tAmount = [tQueryBase].[qAmount];


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK