Change a query

[Warrio]

Hello!!

Is it possible to modify the Sql text of an object query stored in the
database (by code)?

Thanks for any suggestion!

 

[Wayne Morgan]

Yes.

CurrentDb.QueryDefs("MyQuery").SQL = "SELECT * FROM ....."

This can be shortened if you have already defined a querydef object
variable.

qdf.SQL = "SELECT ..."