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
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