I'm trying to build a dynamic sql query using VBA, thing is, i don't know how to assign a certain sql script to a Query in the database from within VBA.
Any help would be appriciated!

Ted de Vries

This article from Microsoft might help you: ACC2000: Query by Form (QBF) Using Dynamic QueryDef (http://support.microsoft.com/default.aspx?scid=kb;en-us;210242).

Thanks for the help dcx693!! This was exactly what I was looking for!