Quote Originally Posted by Spoo View Post
Luca

Sorry if I confused you regarding the "3. create a query" section.
It was intended to be a hypothetical ,, just to demonstrate the syntax.

It could just as easily have been in a separate Sub .. you would, however, need to "redefine"
DB91 prior to issuing the statement Set RSSQL = DB91.OpenRecordset(sSQL), ie, issue
a Set DB91 = Workspaces(0).OpenDatabase(,,something,,) statement.

As for loops, yes, you will need to modify my code frag to suit your needs. I do not see
any "harm" (ie, loss in speed) in issuing a DB91.Close often.

Perhaps you could post the code you have so far so we can get more specific in our replies.

Spoo
Sensible and reserved data are into the code, i can send in pvt?