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