complicated Qry

[GaryPanic]

OK .. here it is
I have transactions in various currencies and I want to extract them into seperate sheets within a xls - (It has to be xls as it is passed on to external companies)

now that would be relatively easy - here the problem ...
multi tax rates and seperating out into 1 sheet per currency per tax
these are the currencies so far (and the tax rates ) the euros coudl be in any country france/germany etc and each has to be seperated out
so 6 x 9 = 54 potential sheets ( highly unlikely but as more currencies and tax rates get added possible )
i could write 54 qry - but that seems daft there must be some way of running 1 qry to filter/export out - but that is way beyound my abilty to comprehen - it would be useful to have some input into the problem

CurrencyName
Sterling
Euros
USD Dollars
South African R
Australian Dollar
Hong Kong Dollar

Tax rate
Tax Name
Insurance Premium Tax (5%) - defaunt
Irish Levy (3%)
Greek Tax
Tax Not Applicable
Italian Tax 21.25%
Insurance Premium Tax 6%
Channel Islands Tax NA
Portugese Tax
Netherlands Tax

 

[liddlem]

Hi Gary
I think that exporting ALL the data to excel is actually a good thing, as you could simply apply a FILTER to the data - by currency/type.

Or is that not an option?