It will probably be quicker to use an update query. Parsing through each record can take a very long time. Things code can do in a few minutes update queries can do in a few seconds. Access is pretty powerful when it comes to querying coding wise it needs some improvements. I am glad I could help.
Stephen Kuhn
Prism Network, Inc.
System Developer
At last we can reveal ourselves to the Jedi.
At last we will have revenge.
-Darth Maul