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]
Nenhum comentário:
Postar um comentário