SQL query question

[jeremypaule]

I’m pretty new to building and SQL query into VBA, but what is the best way to put a SQL query into VBA?

Do you think it is easier to write it from scratch or build a query in access in design view to see if it works? Then, view it in SQL and reformat it to work in VBA? This is in terms of a HUGE query.

 

[KeithG]

If I am writing a complex query with lots of fields I will usaualy build it with the query builder and paste it into my function and make the modifications. But if it is a small simple query I will usually just write the SQL. Using the query design grid there is less chance for human error.

 

[jeremypaule]

thanks, do you happen to have a SQL Select query with two joined tables that have criteria from form combo boxes? I just want to have some type of template to serve as a road map when I try to make a SQL query. thanks!