Query Update with Calculation???

[Mac1206]

If I'm updating Tbl A with Tbl B and within Tbl B I have a column of Prices (20,30, 15,etc...) which I need to multiply by 20 for my update to Tbl A. How would I write this? Thanks in Advance...

Tbl_B Tbl_A Result
Price_Fld Price_Fld
20 400
15 300
5 100
7 140

 

[Joe4]

How are table A and table B joined/related?

 

[Mac1206]

How are table A and table B joined/related?

Hello Joe, they are joined on Product_Code and Product_Hier one-to-one...Hope this helps

 

[Joe4]

In your query, join Tables A and Table B on your two join fields.
Then add the Price_Fld from TableA to the query field to return
Change the query type to Update Query
Then, in the "Update To" line under the Price_Fld, enter the following expession:
[TableB]![Price_Fld]*20

Then run it, and it should do what you want.

 

[Mac1206]

In your query, join Tables A and Table B on your two join fields.
Then add the Price_Fld from TableA to the query field to return
Change the query type to Update Query
Then, in the "Update To" line under the Price_Fld, enter the following expession:
[TableB]![Price_Fld]*20

Then run it, and it should do what you want.

Thanks Joe...you are awesome...Thanks again...

 

[Joe4]

You are welcome!
Glad I could help.