Sorry for the delay, my wife has been using the computer and I have been doing some research in to your original idea of using a query.
Which I now have working, please see the attached database.
If you want to have a form based VBA version let me know.
Reply With Quote