Gillian has attended:
Access VBA course
Excel Advanced course
SQL in VBA
Should many SQL queries be called upon one after the other in VBA? I no longer want to do many Access queries manually. There are about 15 queries to do one after the other on a table I am analysing.
RE: SQL in VBA
Are all the 15 queries action queries?
I don't see a problem running one query after the other in SQL in VBA if they are action queries.
If the queries are all based on each other so it would be one very complex SQL statement combining all the queries that might be a different matter just due to the complexity of the SQL.
Laura