Insert a select SQL into a Update SQL statement

[Marijn]

Hi,



Im quite new at SQL and im having a bit of trouble inserting one SQL query into another.

I hope you can help me out.

I am using a select query in this update statement

DoCmd.RunSQL "UPDATE hlpqry_replace_maand_UWQ INNER JOIN tbl_UWQ ON hlpqry_replace_maand_UWQ.Brondocumentnummer = tbl_UWQ.Brondocumentnummer SET tbl_UWQ.[Datum eBS] = [hlpqry_replace_maand_UWQ].[Datum eBS3];"

The SQL for the "hlpqry_replace_maand_UWQ" is:
SELECT tbl_UWQ.Brondocumentnummer, Replace([Geplande begindatum],"MAR","MAAR") AS [Datum eBS1], Replace([Datum eBS1],"MAY","MEI") AS [Datum eBS2], Replace([Datum eBS2],"OCT","OKT") AS [Datum eBS3] FROM tbl_UWQ;

Can I place the hlpqry SQL into the update statement?

Thanks.

[ranman256]

Dont run these as SQL.
built queries from them, and they should work.

(the easy way)