exporting xls - (complicated)

[GaryPanic]

i have two problems
First-
I need to export into xls a report -however ....
I need to seperate out the following

By currency and by tax
both of which could be lots

example
Sterling may have tax rates from the Uk , Ireland, germany, France, italy greece, Australia etc...

then i could have exactly the same for Euros and then Dollars and then any other currency

Does anyone have any idea on how to export these into a single xls (each on a seperate tab)

I can get the access report to split these out - but I need to dump into excel


second -
The export into xls also how do you get it to total -
I could have 20 entries or i could have 2000 entries any idea's ...
basically it would have to count the number of entries and then have some formula to total ?

regards

 

[CoachPhil]

If you create a report in Access, you can export in Excel. So start by creating the report you would like in Access

 

[DCrake]

Your first point is to create a summary query based on the grouping of the main query, this can be done best using recordsets. Then by enumerating through the summary recordset make extracts from the detail recordset and use these dynasets to export to Excel on individual worksheets using the CopyFromRecordset Method.

David

 

[GaryPanic]

Thanks for your reply's
David yours seems like the most realisitic (thanks Coach-Phil)
I will need to get the book out a read up on this ....

will let you know when I fall over