Thanks, Roger. I knew the concept of how to denormalize, but I never learned Access2003's object structure (e.g., tabledefs, recordset syntax). I downloaded your sample and was able to denormalize my client's table in about 10 minutes. You're a good man . "Roger Carlson" wrote: > On my website (www.rogersaccesslibrary.com), is a small Access database > sample called "NormalizeDenormalize.mdb" which illustrates how to do this > with one particular kind of denormalized file.