Update qry runs ... but I see no changes?

  • Thread starter Thread starter Mercy
  • Start date Start date
M

Mercy

Hi,

I don't know why ... but when I run my update query on
Table A... it seems like everything works ...except when I
open the table ... I see none of the changes! Where are
they hiding?

Below is my update qry:
UPDATE Cloth INNER JOIN Details ON
(Cloth.ProductID = Details.ProductId)
AND (Cloth.PONum = Details.PONum)
SET Cloth.Marked = "Yes"
WHERE Details.OrderNum)=[X];

I've never used an update qry before (newbie) So ... if
anyone can shed some light... I'd be VERY GRATEFUL!

-Mercy
 
Hi Mercy

I have just created these tables and tested it with 'dummy' data and it
seems that your SQL is OK apart from some missing brackets.
Try:

UPDATE Cloth INNER JOIN Details ON
(Cloth.ProductID = Details.ProductID)
AND (Cloth.PONum = Details.PONum)
SET Cloth.Marked = "Yes"
WHERE (((Details.OrderNum)=[whatever]));

Hope that resolves it !

Jake
 
Mercy,

How are you running the update query? Are you just switching to the datasheet
view? If so, that does not update the records.

To actually run the update query, you need to click on the Red Exclamation sign
in the toolbar or select Query: Run from the menu.

If you already knew the above, then please be aware that I'm not trying to be
condescending. You did say you were a newbie and I have seen this
"misunderstanding" occur in the past with newbies.

Jacob said:
Hi Mercy

I have just created these tables and tested it with 'dummy' data and it
seems that your SQL is OK apart from some missing brackets.
Try:

UPDATE Cloth INNER JOIN Details ON
(Cloth.ProductID = Details.ProductID)
AND (Cloth.PONum = Details.PONum)
SET Cloth.Marked = "Yes"
WHERE (((Details.OrderNum)=[whatever]));

Hope that resolves it !

Jake

Mercy said:
Hi,

I don't know why ... but when I run my update query on
Table A... it seems like everything works ...except when I
open the table ... I see none of the changes! Where are
they hiding?

Below is my update qry:
UPDATE Cloth INNER JOIN Details ON
(Cloth.ProductID = Details.ProductId)
AND (Cloth.PONum = Details.PONum)
SET Cloth.Marked = "Yes"
WHERE Details.OrderNum)=[X];

I've never used an update qry before (newbie) So ... if
anyone can shed some light... I'd be VERY GRATEFUL!

-Mercy
Click to expand...
Click to expand...
 
Back
Top