Link to home
Start Free TrialLog in
Avatar of John Sheehy
John SheehyFlag for United States of America

asked on

Export joined tables to one excel preformatted template

Here's my dilemma.
I have two tables, tblPOAM and tblPOAMMilestones.  PK/FK linked
The tables, queries and forms work just fine.

I can export just the tblPOAM to an excel preformatted template.
But I can not get the tblPOAMMilestones to export correctly.

The Milestones need to show under the POAM item.

See attachment for an example of the output.  Notice that rows 2-4 have the same key and 4 and 5 do not.  

Maybe I am going about this the wrong way so any suggestions would be helpful.
Avatar of John Sheehy
John Sheehy
Flag of United States of America image

ASKER

Forgot the attachment
Experts.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Dale,
I am going to try option 1. Thanks for the quick response.  I will have questions concerning option 1 I am sure.  I will let you know.

Thanks,
John
I haven't forgotten about this.  It has taken the past week to align all the tables and forms so this will work.  But the amount of time it will save is going to be 1000 times greater.  So this will be worth it.  I should have a question out here today.  I am making the last change to the table and need to ensure it looks ok on the form and in one of the exports.
Here's the update.
I have the export working and everything is formatted correctly.

I can get it to loop through the records but how do I tell it to delete the the data in the first 6 columns if the POAM Key of the current row is the same as that of the previous row.

Thanks
John
Dale pointed me in the right direction.  Just need to figure a few things out.