Hi Gang
I'm attempting to use a query that John V. gave us years ago. It is supposed to update a table with data from another table, and if the records are not in the first table they should be inserted into it.
Example:
UPDATE tblCostCenters_lkp RIGHT JOIN vEPSi_CostCenters
ON tblCostCenters_lkp.CostCenter = vEPSi_CostCenters.CC
SET tblCostCenters_lkp.CostCenter = [vEPSi_CostCenters].[CC]
, tblCostCenters_lkp.CCDescr = [vEPSi_CostCenters].[CCDescr];
I try to run this and get a "not updateable query". It runs as a SELECT query without any complaints and I know all the data types mattch. tblCostCenters_lkp is certainly updateable because I've been doing this manually for a while now. Any ideas?
-Bill Mosca
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar