T
Tony Williams
I have two tables tblmain and tblturnover. The second table tblturnover
includes data for a number of companies for different dates and I want to
import the data from tblturnover to tblmain for each compnay. I have tried
using an append query but it just adds the data as additional data rather
than adding it to the existing compnay records in tblmain.
To illusttrate:
tblmain
txtcompany............txtdate............data1...............data2.........data3.............etc
tblturnover
txtcompany............txtdate............data1...............data2.........data3.............etc
I want to add the values of data1, data2, data3 etc from tblturnover to the
fields data1, data2, data3 etc in tblmain where tblmain.txtcompany and
tblmain.txtdate equal tblturnover.txtcompanyand tblturnover.txtdate
Anyone help?
Thanks
Tony
includes data for a number of companies for different dates and I want to
import the data from tblturnover to tblmain for each compnay. I have tried
using an append query but it just adds the data as additional data rather
than adding it to the existing compnay records in tblmain.
To illusttrate:
tblmain
txtcompany............txtdate............data1...............data2.........data3.............etc
tblturnover
txtcompany............txtdate............data1...............data2.........data3.............etc
I want to add the values of data1, data2, data3 etc from tblturnover to the
fields data1, data2, data3 etc in tblmain where tblmain.txtcompany and
tblmain.txtdate equal tblturnover.txtcompanyand tblturnover.txtdate
Anyone help?
Thanks
Tony