Hot Fox: Re: [Access VBA Central] De Normalizing a Parent Child Table in Export

Not sure if you got this solved but here's a generic query that should do it once you apply to your specific situation

SELECT P.Field1
C.Field1
FROM ParentTable P, ChildTable C
WHERE P.KeyField = C.KeyField
ORDER BY P.Field1, C.Field1

Once you have the query all you need to do is export. I'd export it to a CSV file then open it and tweak it then save it as an Excel Spreadsheet. Why the two step process -- because you are going to have to tweak the spreadsheet to fix the column widths and bold the headers (at least). And you never know they may want you to do something else with that data in future and if you date those CSV files you have them for ease of use later on.

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (4)

Recent Activity: