I Badly Need Your Help

  • Thread starter Thread starter Arvin Villodres
  • Start date Start date
A

Arvin Villodres

Good day to everyone!

I need to update a table from a different database in a
different directory
having "totals" as its tablename and ItemIDGroup,
ItemDescGroup, TotDel for
its field names. The table in the current direcetory that
would update
"totals" is "Trivia" with ItemID, ItemDesc, and
SumOfQtyDelivered for its
fieldnames.

I made this SQL statement:

UPDATE totals
IN 'N:\MMS CENTRAL\IC\ictot.mdb'
INNER JOIN Trivia
ON totals.ItemIDGroup = Trivia.ItemID
SET totals.ItemIDGroup = [ItemID], totals.ItemDescGroup =
[ItemDesc], totals.TotDel = [SumOfQtyDelivered];

But if I try to run it a message "Syntax Error on Update
Statement" would appear.
What did I do wrong?

Thanks.
 
Arvin Villodres said:
Good day to everyone!

I need to update a table from a different database in a
different directory
having "totals" as its tablename and ItemIDGroup,
ItemDescGroup, TotDel for
its field names. The table in the current direcetory that
would update
"totals" is "Trivia" with ItemID, ItemDesc, and
SumOfQtyDelivered for its
fieldnames.

I made this SQL statement:

UPDATE totals
IN 'N:\MMS CENTRAL\IC\ictot.mdb'
INNER JOIN Trivia
ON totals.ItemIDGroup = Trivia.ItemID
SET totals.ItemIDGroup = [ItemID], totals.ItemDescGroup =
[ItemDesc], totals.TotDel = [SumOfQtyDelivered];

But if I try to run it a message "Syntax Error on Update
Statement" would appear.
What did I do wrong?
Click to expand...
Hi Arvin,

The following works in my test dbs
(obviously not exactly same, but I know works)

UPDATE
[Select PK, f1
FROM tbl1 IN "C:\another.mdb" ]. AS t
INNER JOIN tblLocal
ON t.PK = tblLocal.ID
SET t.f1 = tblLocal.AValue;

Now...whether I can type correctly...

UPDATE
[Select
ItemIDGroup,
ItemDescGroup,
TotDel
FROM totals
IN 'N:\MMS CENTRAL\IC\ictot.mdb']. AS t
INNER JOIN Trivia
ON t.ItemIDGroup = Trivia.ItemID
SET
t.ItemIDGroup = Trivia.ItemID,
t.ItemDescGroup = Trivia.ItemDesc,
t.TotDel = Trivia.SumOfQtyDelivered;

Besides poor typing skills, there may
be something else wrong that I have missed.

Please respond back if I have misunderstood.

Good luck,

Gary Walter
 
Back
Top