Transpose Query Result (1 Viewer)

[JithuAccess]

Hello Guys,

I have a Table to store the Total of Expenses in a Financial Year. I have created queries to break down the Expenses by Month (April, May and June). Then I have created another query to combine these. This is my Query Result:

I want to transpose this Query Result like:

Could you guys please let me know how to do this?

I am attaching my Database.

Thanks a lot

 

[arnelgp]

Use total query?

 

[June7]

Just use your table in an aggregate (TOTALS) query. Or build a report and use its Sorting & Grouping features with aggregate calcs. This allows display of detail data as well as summary info.

Also, the result you posted can be obtained with a CROSSTAB query. Review http://allenbrowne.com/ser-67.html