View Full Version : Report from Query - transpose Dates


Scottie31
01-10-2006, 07:09 PM
I am trying create a report from a query and I am using serveral dates in the query. When the query or report is run the dates are displayed in a column. Is there any way that I can have the dates displayed in rows.

This is what I get:

jan 1
jan 2
jan 3
jan 4


This is what I want:

Jan 1 Jan 2 Jan 3 Jan4

Any help would be appreciated.

Thanks,
Scott

ScottGem
01-11-2006, 10:51 AM
Go to File>Page Setup in Report design mode. Set the report to be in columns and set the columns to Across then Down.