By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,369 Members | 950 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,369 IT Pros & Developers. It's quick & easy.

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

P: 13
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?
Feb 26 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
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)
Feb 27 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.