Access Reports -- Getting the dates to go horizontally and not vertically

[AimeeRae]

I need to create a report based off the following table (column headings):

Station/Date/TransType/Offer1/Offer2

Station can be either: (KTTB or WOA)
Date is variable
TransType can be either: (Inquiry, lead or new order)
Offer 1 is a number
Offer 2 is a number


I need the report to have the station running vertically down the page with offer 1/offer 2 and the date to list out horizontally (so we can see a whole weeks worth of info on one page.)

How do i do this?

[nico5038]

I need to create a report based off the following table (column headings):

Station/Date/TransType/Offer1/Offer2

Station can be either: (KTTB or WOA)
Date is variable
TransType can be either: (Inquiry, lead or new order)
Offer 1 is a number
Offer 2 is a number


I need the report to have the station running vertically down the page with offer 1/offer 2 and the date to list out horizontally (so we can see a whole weeks worth of info on one page.)

How do i do this?

You'll need a crosstable report for this. I would start with a query like:
select Station, Format(Date,"yyyy-ww) as YearWeek, Weekday(Date) as DayOfWeek, TransType, Offer1 & " " & Offer2 as Offer from tblYours;

Now use this query in a crosstable query and set:
Station Rowheader
YearWeek Rowheader
TransType Rowheader
DayOfWeek ColumnHeader
Offer Value
Finally change for the Offer the "GroupBy" into "Max"

This would give a query you can use for your report, assuming all weekdays are always present.

Nic;o)