How to update Calculated Query into another table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm using Access2003

I've created a math query which calculates Amount: [Units] * [PricePerUnit].
When i run the query, Dialog boxes appear and i have to fill the Units box,
then the PricePerUnit box. After that, Access Opens the query result windows
and displays 3 collums [Units], [PricePerUnit] and [Amount] with all the
correct figures. How do i link / extract the Amount figure into my [Sales
Register].[TotalPrice] field?

Thanks Allen for your suggestion with doing the calculations in a query.
 
Daniel said:
Hi,

I'm using Access2003

I've created a math query which calculates Amount: [Units] *
[PricePerUnit]. When i run the query, Dialog boxes appear and i have
to fill the Units box, then the PricePerUnit box. After that, Access
Opens the query result windows and displays 3 collums [Units],
[PricePerUnit] and [Amount] with all the correct figures. How do i
link / extract the Amount figure into my [Sales
Register].[TotalPrice] field?

Thanks Allen for your suggestion with doing the calculations in a
query.
Click to expand...

If you are doing this in a query there is no need to, and in general, you
should not place the results in a field.
If you were doing this in a form using a related table to find prices as
would normally be done you *might* want to fix the pricePerUnit by adding it
to a table since a future reference to this record might reflect a different
price. Even in this case the calculated amount would remain a calculation.

If you still want to do this you will have to run an update query to place
the amount into a field you would update TotalPrice (Brackets are not needed
unless the field has spaces) with Units*PricePerUnit by placeing that
equation in the "update To" field.
 
Back
Top