how do I combine Select and Update queries

[David Powell]

Hello. I am trying to combine a Select and Update Query. Essentially what I
am trying to do is Select Records by a Yes flag, have a statement added to a
subform to say leaflet sent together with the date, the yes flag will then be
updated to No. I have forgotten most of what I did know about access. I
have attempted to merge two SQL query with no success as below.

SELECT [sols somerset wilts (3)].[Mailing?]
FROM [sols somerset wilts (3)]
WHERE ((([sols somerset wilts (3)].[Mailing?])=Yes))
UPDATE [sols somerset wilts (3)], Updates SET [sols somerset wilts
(3)].[Mailing?] = No, Updates.Notes = "Details Sent", Updates.[Update Date] =
Date();

My language skills are nil so any help would be gratefully received.

Regards, David

 

[Klatuu]

You are going to have to provide more detail. The SQL you are trying to use
will not work at all. It also looks like you are trying to update two
different tables.

If you can describe in great detail what you want it to do, I can show you
how to do it.