When working with queries, how do I know which to use SQL or VB? Am confused.
Queries ONLY use SQL. You can use VBA to create, open or modify a Querydef.
Forum Rules