If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data from one table to another q
Hello,
Can some one help me to pull data from one table to another. I have two tables Table 1 - Amount estimation Table 2 - Payments Now I want to calculate the variation between amount received and expected amount. But the problem is in Payments I dont have expected amount. Is it possible to link or do something to auto populate expected amount from in Payments form. field names are Expected Amount (ID) - in table amount estimation Actual amount (ID) - in table payments Please advice Thanks, DA -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
#2
|
|||
|
|||
Data from one table to another q
Hi DA,
If there is some way of linking the tables through a primary key/foreign key pair, then you can simply link them on those fields then utilise fields from each table in your query. eg: Select * from [Amount Estimation] inner join [Payments] on [Amount Estimation].ID = [Payments].ID Damian. "dinadvani via AccessMonster.com" wrote: Hello, Can some one help me to pull data from one table to another. I have two tables Table 1 - Amount estimation Table 2 - Payments Now I want to calculate the variation between amount received and expected amount. But the problem is in Payments I dont have expected amount. Is it possible to link or do something to auto populate expected amount from in Payments form. field names are Expected Amount (ID) - in table amount estimation Actual amount (ID) - in table payments Please advice Thanks, DA -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
#3
|
|||
|
|||
Data from one table to another q
I forgot to mention the criteria the unique id no. is "Service ID" based on
which the expected amount (ID) should get auto populated dinadvani wrote: Hello, Can some one help me to pull data from one table to another. I have two tables Table 1 - Amount estimation Table 2 - Payments Now I want to calculate the variation between amount received and expected amount. But the problem is in Payments I dont have expected amount. Is it possible to link or do something to auto populate expected amount from in Payments form. field names are Expected Amount (ID) - in table amount estimation Actual amount (ID) - in table payments Please advice Thanks, DA -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
Thread Tools | |
Display Modes | |
|
|