crosstab query

[Guest]

I'm building a crosstab query.
Is it possible to make the sum of two different valu under the month.

Example under january column two amount in $ & Euro separately.

 

[Jeff Boyce]

Tony

That sounds like two different queries.

Have you looked into doing two queries, one w/ $, one with Euros, then
showing both in a report?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/