I maintain an application developed in Access. And I have to implement an update query, but I'm quite stuck at the moment and I don't understand why.

Basically, the query must update a record from table X following another record from that same table, but the query I wrote does nothing, I did test separately the update and the select and they both work, but together, no.

I hope some of you may found my problem.

Here is the query I wrote (I did remove some fields to avoid to be too long, and of course, the query you will see was tested to be sure it was not the missing fields the issue)

```
UPDATE 
    TABLE_X AS recordToUpdate,
    (
    SELECT 
        DUP_C2B_From_CPL.[NUM-GrpHdr], 
        DUP_C2B_From_CPL.[NUM-LOT], 
        DUP_C2B_From_CPL.[SINGLE-SCENARIO], 
        DUP_C2B_From_CPL.EqvtAmt, 
        DUP_C2B_From_CPL.EqvtAmtCur, 
        DUP_C2B_From_CPL.EqvtAmtCurTft, 
        DUP_C2B_From_CPL.XchgRateInfExchangeRate, 
        DUP_C2B_From_CPL.XchgRateInfRateType, 
        DUP_C2B_From_CPL.XchgRateInfContractId, 
        DUP_C2B_From_CPL.ChqTp

        FROM DUP_C2B_From_CPL
    ) AS originalRecord

SET
    recordToUpdate.EqvtAmt = originalRecord.EqvtAmt, 
    recordToUpdate.EqvtAmtCur = originalRecord.EqvtAmtCur, 
    recordToUpdate.EqvtAmtCurTft = originalRecord.EqvtAmtCurTft, 
    recordToUpdate.XchgRateInfExchangeRate = originalRecord.XchgRateInfExchangeRate, 
    recordToUpdate.XchgRateInfRateType = originalRecord.XchgRateInfRateType, 
    recordToUpdate.XchgRateInfContractId = originalRecord.XchgRateInfContractId, 
    recordToUpdate.ChqTp = originalRecord.ChqTp 

WHERE
    recordToUpdate.[SINGLE-SCENARIO] = 112811

```

**DUP\_C2B\_From\_CPL** here is a subQuery that is retrieving the record I'm interested in so I can take its values to update the other one.

In the last WHERE closure, I hardcoded the id for more readability for you (and yes it exists :))

And also the designer is rendering correctly, so no error on this side. But as I said, it seems that it is not updating anything.

Don't hesitate to tell me if you nee more information.