Spreadsheet looks like a calendar

  • Thread starter Thread starter Tom Tripicchio
  • Start date Start date
T

Tom Tripicchio

Is it possible to have my data printout in a calendar type format? My
example would be each salesman sells X amount of items per day. Is there a
way for it to show up in a calendar format?

ex.
Sunday|Monday|Tuesday|Wednesday|Thursday|Friday|Saturday|

week nov 28 4 0 7 4
3 0 0
week dec 4 6 8 7 5
2 1 0

And so on.

Thanks for the help.
 
Tom,

I have a calendar module that I developed that displays data in each day of
the calendar. Any year and any month can be selected, and the data in the
calendar will be for the year and month selected. The calebdar can also be
printed out as a report. I developed the calendar to be able to schedule and
display training classes but it can be adapted to show any kind of activity
each day or any kind of data each day. If you would like my help adapting my
schedule calendar to display your data, contact me at my email address
below.
 
Hi Tom.
Yesy you could do that, I assume you have the data with a salesman, a date,
and an amount. Possibly multiple amounts per day.

What you could do is create a crosstab query where you would use the
salesman as the first row header, the second row header would be
Val(format([yourdate],ww)) the column header would be format([yourdate],ddd)
and the calulated field would be the sum of amount.
You can put a filter to limit the data to the time period you wish.
Hope this helps.
Fons
 
The only problem that I have, unless I am doing it wrong which might be
true, is that I need to have the whole month showing and each week on its
own line.


Fons Ponsioen said:
Hi Tom.
Yesy you could do that, I assume you have the data with a salesman, a
date,
and an amount. Possibly multiple amounts per day.

What you could do is create a crosstab query where you would use the
salesman as the first row header, the second row header would be
Val(format([yourdate],ww)) the column header would be
format([yourdate],ddd)
and the calulated field would be the sum of amount.
You can put a filter to limit the data to the time period you wish.
Hope this helps.
Fons

Tom Tripicchio said:
Is it possible to have my data printout in a calendar type format? My
example would be each salesman sells X amount of items per day. Is there
a
way for it to show up in a calendar format?

ex.

Sunday|Monday|Tuesday|Wednesday|Thursday|Friday|Saturday|

week nov 28 4 0 7 4
3 0 0
week dec 4 6 8 7 5
2 1 0

And so on.

Thanks for the help.
Click to expand...
Click to expand...
 
Back
Top