Hi, I apologize off the bat if this is just a ridiculous question that I should know the answer to. I've tried to find the answer but can't figure it out.



I have 2 tables: TBL_Main and TBL_Type. In a form I created, the TBL_Main data makes up the form which includes a persons name, address, etc and the TBL_Type is used in a subform which includes various activity a person does. So, for each person in the table, they may have up to 10 items in the subform. This has worked excellent jsut for researching puropses, but my boss now wants me to export this data to an excel worksheet. I can export one table, and I can export the other, but for the life of me, I can't figure out how to export them so that the data is together in Excel.

Does this make any sense? Can anyone help me out? I would DEEPLY thankful for ANY help I can get!!!!

-jj