John Sheehy
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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 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
ASKER
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.
ASKER
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
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
ASKER
Dale pointed me in the right direction. Just need to figure a few things out.
ASKER
Experts.xlsx