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

[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

 

[Jacob Frankham]

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

 

[John Spencer (MVP)]

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.

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

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