BallunarCrew
Programmer
I have a parent table with two children. When I simply create a query and export it to Excel, I have what appears to be duplicate rows of the parent data due to the two children and the magic of the Cartesian products databases do for us. I need the Excel export to not show the duplicate data - blank cells in Excel are what we are after.
What I get:
App Status LanguageChild ServerChild
IADB Active Visual Basic Server1
IADB Active MS Access Server1
IADB Active Visual Basic Server2
IADB Active MS Access Server2
What I want:
App Status LanguageChild ServerChild
IADB Active Visual Basic Server1
MS Access Server2
I created a report with two sub-reports - looks great in Access - one sub-report next to the other. Export to Excel and it rearranges the sub-reports so the sub-reports are now on top of each other. I created a de-normalized temp table with as many child fields as possible based on the data - Language1, Language2, Language3, etc up to 44 since the max number of Languages per any app is 44. On the report, I stacked these fields as I want and did the same for the other child table. This report is great in Access but when exported to Excel, it unstacks them and puts them beside each other.
Bottom line - I want to Export to Excel and have Access not rearrange my data. Any ideas are greatly appreciated.
What I get:
App Status LanguageChild ServerChild
IADB Active Visual Basic Server1
IADB Active MS Access Server1
IADB Active Visual Basic Server2
IADB Active MS Access Server2
What I want:
App Status LanguageChild ServerChild
IADB Active Visual Basic Server1
MS Access Server2
I created a report with two sub-reports - looks great in Access - one sub-report next to the other. Export to Excel and it rearranges the sub-reports so the sub-reports are now on top of each other. I created a de-normalized temp table with as many child fields as possible based on the data - Language1, Language2, Language3, etc up to 44 since the max number of Languages per any app is 44. On the report, I stacked these fields as I want and did the same for the other child table. This report is great in Access but when exported to Excel, it unstacks them and puts them beside each other.
Bottom line - I want to Export to Excel and have Access not rearrange my data. Any ideas are greatly appreciated.