Do you want to do it as a macro? VB Automation? What version of access are you in. Willing to help, but details help us to give you better information petersdaniel@hotmail.com
"If A equals success, then the formula is: A=X+Y+Z. X is work. Y is play. Z is keep your mouth shut." --Albert Einstein