Store data from one table in an other table.

[Hasse]

I am a beginner working with access (2013).
I am looking for a way to retrieve data from one table and store these values in a other table. The tables are in the same database.
For exampel:
Table 1
Input [OrderNr]
Input [Nr] (linked to Table 2 [ID]
Input [Amount]
From Table 2
Get [Product]
Get [Unit]
Get [Price]
[TotalPrice] =[Amount] * [Price]

The result should be wiewed as a datasheet.

Problem 1
I have made the form and the links between the tables and it works allright on screen.
Except the sum-function It does not work. I can only get the amount of items in the summery field for column TotalPrice.


Is it because it is a column for calculated values? Other columns including not calculated numeric values works allright with the sum-function.
Is there a solution for that?

Problem 2
The data from table2 vill not be stored in table 1
Is there a solution for that?

Hopefully
Hasse

[pbaldy]

Is this what you're after?

BaldyWeb - Autofill