Which method is quickest.

[striker]

Does anyone know which is the quickest method of querying data.

1. Creating a query and then running that query using a do.cmd call.

or

2. Actually writing the query code within a procedure.

 

[cogent1]

Saved queries execute faster than coded SQL statements. But in a small database, the difference is probably not noticeable.

 

[The_Doc_Man]

If you count the development time and the absolute simplicity of changing the query, using a stored query is MUCH faster all the way around, in building, testing, and running.

 

[Fornatian]

Writing a query in VBA is only done where it is built dynamically for whatever reason. Even then this can be worked around using different queries and if..then statements.

Essentially, you trade off speed of processing to being able to dynamically tailor a query