Report from Query - transpose Dates

[Scottie31]

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]

Go to File>Page Setup in Report design mode. Set the report to be in columns and set the columns to Across then Down.