VBA Query Best Practices advice needed

[psycoperl]

Good Morning,
I need some advice on a project that I am working on.

I am trying to see Would running a single query and then iterating through each record multiple times to check for each error be better than running multiple queries where only problems are returned??

The scenario: As part of a mailing list generation process, we pull records that are supposed to be mailed into tblTempMailing for processing.
We then run error checks to ensure that the data in the letters is correct and formatted properly so that the letters don't get bounced or reciepents are unable to respond.

 

[xenou]

It's hard to say. If the error-checking involves a lot of string matching tests, you might have better luck going through a recordset and running the tests on each record in turn. But if it's simpler stuff like "zip code not null" then a query would probably be fastest, especially if the field were indexed. If the data set is fairly small then it probably makes little difference either way - I'd start with what is simplest, and see how it goes from there.