union query very slow

[Ssstacey]

Hi,
In my database im using several union queries as they turn out to be very useful.
However, whenever I have a calculation that involves one of the union queries, things happen at a very slow pace. Is there a way to speed it up a bit?
Thank you
Stacey

 

[KenHigg]

You may be able to add an index or two and speed things up a bit. Just don't create an index to be creating one though, this could slow it down even more!

 

[Ssstacey]

Thanx..
I put a few index, but no change..

 

[KenHigg]

Are your calculations pretty straight up or do they contain functions like dlookup()'s, etc?

 

[Ssstacey]

Hi,
It might be indeed a normalisation problem.
With im trying to avoid by using these union queries is the folllowing.
I have a query consists (among others) of the following:
product| currency|yield| year|month|conversionrate_curr1|conversionrate_curr2

I need the query to check the currency and convert it with the corresponding conversionrate AND put it all back in one field.
Any idea how I can solve this without using the union query?
Thank you in advance