Faster way to export data to xml with attributes

[Benjamins via AccessMonster.com]

Hi

Below is the query info that had done the the filter of information

Company Remark Amount
======= ========= ========
ABC Company aaaaaaa 100
DEF Company bbbbbbb 200
ABC Company cccccccc 300
GHI Company ddddddd 400
...
...
...

I need to export this info to an XML file with the following Information

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<Report>
<ReportInfo>
<ReportTitle>TITLE</ReportTitle>
<ReportDetail />
<PeriodStart>2009-01-01</PeriodStart>
<PeriodEnd>2009-12-31</PeriodEnd>
<Company Name="ABC Company" TotalAmt="400">
<Line>1</Line>
<Desctipn>aaaaaaa</Line>
<Amt>100</Amt>
<Line>2</Line>
<Desctipn>cccccccc</Line>
<Amt>300</Amt>
</Company>
<Company Name="DEF Company" TotalAmt="200">
<Line>1</Line>
<Desctipn>bbbbbbb</Desc>
<Amt>200</Amt>
</Company>
<Company Name="GHI Company" TotalAmt="400">
<Line>1</Line>
<Desc>ddddddd</Desc>
<Amt>400</Amt>
</Company>
</ReportInfo>
</Report>

I have 100s of xml file to export and all the information is different thus i
am try to find a faster way rather that hard coding all of them.

I have use the Export XML code But it did not give company info as what i
need.
I have done hard coding but it will be tedious to apply it to all the other
report.

Any Suggestion?

Thanls.