Access Report Column/Date Help!

[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.)

Report should look like this:

Station 02/01/2007 02/02/2007 02/05/2007
TransType Offer1 Offer2 Offer1 Offer2 Offer1 Offer2
KTTB-FM
Inquiry 3 10 7 12 4 18
Lead 6 10 5 3 8 10
New Order 2 4 3 2 4 7
WOA-AM
Inquiry 6 5 4 9 8 26
Lead 8 6 12 9 15 20
New Order 5 4 6 5 11 8

How do I do this?

 

[LaurieHamlin]

Take a look at crosstab forms. I often use forms as reports because they have much more functionality. It'll look more like this, if this will work.
02/01/2007 02/02/2007
Station TransType Offer1 Offer2 Offer1 Offer2
KTTB-FM Inquiry 3 10 7 12
KTTB-FM Lead 6 10 5 3

 

[aimeerae]

Hi Laurie-

Forgive my ignorance...but where are the crosstab forms?