List to Pivot format

[ria.arora]

Hi All

Is there any way to show list data in tabular format using SQL query in MS Access?

Private BankerYearMonthVolatile IncomeJames2012013244James2012023467James2012034667James2012045668James2012052378Andrew201201345Paul2012013456Paul201202-234Paul2012030Paul2012040Paul2012053456

Show above date in below format in Excel

Banker201201201202201203201204201205Andrew345 James32443467466756682378Paul3456-234003456

Thanks in advance for the help

 

[vbaInet]

You need to amend the formatting. Or just put in a spreadsheet and upload.

 

[ria.arora]

Sorry for the formatting of the file.

Please find attached here excel file for the formatted sheets.

 

[vbaInet]

What you need is a Crosstab query.