Cross Query Monthly Calc

[Vinnie via AccessMonster.com]

Hi,

I've got three queries that each show a month ("mmm-yy") and a cost
attributable to that month.

I need three separate queries for three separate currencies.

What I'm looking to do is have one query that shows one month column and the
three cost columns, so that eventually I'll be able to select a month and see
the costing for that month.

At the moment, I've got the the three queries joined by month in the design
part of the query. I'm then showing one of the month fields and the three
cost fields.

However, I don't think what I've done is right as it's not showing all the
months when I run the query. I think this is because for some currencies
their was no cost for a particular month, and probably because of the way
I've designed the query, it only shows months that have costs attributable
across all three currencies.

Any help would be great!

Thanks,

 

[Jeff L]

It sounds like what you'd like to do can be accomplished with a Cross
Tab query. You will need to change how you are querying your data
though. Look it up in help for more info.