Yes… you’re absolutely right. When I was actively writing and supporting db development, I often championed the superiority of recordsets. I’ve just forgotten… pity. Susan H. Doh! That's the trouble with starting from a pre-conception. A DAO solution is probably easier than SQL in this situation. -- Stuart