Report Going Across

[CCFL]

This driving in crazy because I know it can be done but I figure it out. I have a query combining 3 different tables - each has the same field but different info, each table is labeled and connected by a date field. I know how to create a report that can list going the down the page.

This is how the report is looking now:

date table amount
5/28/10 aa 123
5/28/10 bb 456
5/28/10 cc 348
5/27/10 aa 345
5/27/10 bb 445
5/27/10 cc 345

But this is what I would like to do; change the layout to across:

aa bb cc
5/28/10 123 456 348
5/27/10 345 445 345

Any ideas???? Help...Thanks in advance

 

[Galaxiom]

Search CrossTab query.

 

[CCFL]

Thanks, I will do right now.

 

[CCFL]

It worked perfectly, Thanks Again! I knew it possible but I had no idea what it was called or where to look.

Here are some notes if anyone is like me and wondering how to create a crossetab query in Access 2007:

1. On the Create tab, in the Other group, click Query Wizard.
2. In the New Query dialog box, click Crosstab Query Wizard, and then click OK. The Crosstab Query Wizard starts and does the rest.