N
Newbie
I have a table - tblSummary - with four fields:
JobNo-----PrimaryKey
Sales
Costs
Retention
I have a query - qSales - that has two fields:
JobNo
TotalSales
I want to update tblSummary with the TotalSales figure from qSales.
I have tried an update query but it comes back with the message that I need
to use an updateable query???
The JobNo only appears in both sides once.
If I put the results of the query into a table and then use the table to
update it works fine eg
UPDATE tblSales INNER JOIN tblProjectSummary ON Sales.JobNo =
tblProjectSummary.JobNo SET tblProjectSummary.Sales = [TotalSales];
How can I do this without having to create the Sales table first i.e.
updating the tblSummary straight from the qSales query
Thanks
JobNo-----PrimaryKey
Sales
Costs
Retention
I have a query - qSales - that has two fields:
JobNo
TotalSales
I want to update tblSummary with the TotalSales figure from qSales.
I have tried an update query but it comes back with the message that I need
to use an updateable query???
The JobNo only appears in both sides once.
If I put the results of the query into a table and then use the table to
update it works fine eg
UPDATE tblSales INNER JOIN tblProjectSummary ON Sales.JobNo =
tblProjectSummary.JobNo SET tblProjectSummary.Sales = [TotalSales];
How can I do this without having to create the Sales table first i.e.
updating the tblSummary straight from the qSales query
Thanks