CrossTab report "super" columns

[jeff_initial_a]

I am trying to "group" report columns, in this case weekending dates, by
their respective months as
column headings. The report detail itself would be the value of the day of
the week, i.e. Monday thru Sunday,
so that it emulates a calendar. As the data is voluminous I would like to
get as many months across
the report as possible. I do one month at a time using a select query and
the sum(iif(day 0f week =1,
widsets sold,0) technique. But can't figure out how to get several months
across.



This would be the design:

Month(name)
WeekEnding Date(1) WeekEnding Date(2) WeekEnding Date(3)
WeekEnding Date(4)
mon tue wed thu fri sat sun mon tue wed thu fri sat sun mon
tue wed thu fri sat sun etc.

Sales District
Salesperson Name
Widget Name #sold #sold #sold

Thanks!

 

[Steve]

Hello!

A line chart would better show your daily sales. The Y axis would be number
sold and the X axis would be the days.

If you really want a calendar, I could implement a one monthe calendar where
the month is selectable. The calendar would look like a page torn from a
wall calendar. In each day of the calendar would be the number of widgets
sold that day. I provide fee based help with Access, Excel and Word
applications. My fee to implement the calendar for you would be very
reasonable. If you want my help, contact me.

Steve
(e-mail address removed)

 

[Duane Hookom]

I would use the solution found at http://www.tek-tips.com/faqs.cfm?fid=5466.
You would need to change the month intervals to days.

 

[John... Visio MVP]

If you really want a calendar, I could implement a one monthe calendar
where the month is selectable. The calendar would look like a page torn
from a wall calendar. In each day of the calendar would be the number of
widgets sold that day. I provide fee based help with Access, Excel and
Word applications. My fee to implement the calendar for you would be very
reasonable. If you want my help, contact me.

Steve

Stevie is our own personal troll who is the only one who does not understand
the concept of FREE peer to peer support!

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

John... Visio MVP

 

[jeff_initial_a via AccessMonster.com]

I would use the solution found at http://www.tek-tips.com/faqs.cfm?fid=5466.
You would need to change the month intervals to days.

I am trying to "group" report columns, in this case weekending dates, by
their respective months as

[quoted text clipped - 22 lines]

.

thank you!

 

[Duane Hookom]

Let us know if you need some free assistance.

Duane Hookom
MS Access MVP

I would use the solution found at
http://www.tek-tips.com/faqs.cfm?fid=5466.
You would need to change the month intervals to days.

I am trying to "group" report columns, in this case weekending dates, by
their respective months as

[quoted text clipped - 22 lines]

.

thank you!