Access 2003 macro

  • Thread starter Thread starter NoTechDude
  • Start date Start date
N

NoTechDude

I have a macro that takes data from several queries to create a table. When a
query has no data to display it stops the macro. Is there a way to skip the
query that has no data and continue to the next one? Should I use VBA code
instead of a macro and queries for this?
 
I was using select queries at first with basic "select all records' and
"paste" functions. I have changed the queries to "append" queries and it has
solved my problem. Probably not the cleanest way to go, but my coding skills
aren't quite good enough to tackle without someone holding my hand. Thanks
for the reply.
 
Back
Top