Calendar Report

Hi, I would like a report which prints out a weekly itinerary plan for our
employees. I have looked at Duane Hookom's reports but they don't quite
achieve what I want and not too sure how to replicate something similar. I
want a layout like below:

Mon Tues Wed Thurs Frid
3 4 5 6 7
Fred Bloggs Audit Meeting Travel Audit Office
1234 4567
Jane Doe Audit Audit Audit Audit Audit
9876 9876 9876 9876 9876
Bilbo Baggins Holiday Holiday Holiday Holiday Holiday

I am new to crosstab queries and tried to do one of these to diplay the info
but couldn't get it to work as the details I want displayed (audit, dealer
no, etc) are the values of fields rather than a calculation. Can anyone
advise me how to produce a simple report displaying the data in this format?
I will add a start and end date filter to a form to display which week I want
printed, I am just not sure how to get a report in this layout?

Thanks in advance for any help.
Sue

If the calendar reports don't work for you then try look at the crosstab
reports at http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

--
Duane Hookom
MS Access MVP
--


"hughess7" wrote in message
...
Hi, I would like a report which prints out a weekly itinerary plan for our
employees. I have looked at Duane Hookom's reports but they don't quite
achieve what I want and not too sure how to replicate something similar. I
want a layout like below:

Mon Tues Wed Thurs Frid
3 4 5 6 7
Fred Bloggs Audit Meeting Travel Audit Office
1234 4567
Jane Doe Audit Audit Audit Audit Audit
9876 9876 9876 9876 9876
Bilbo Baggins Holiday Holiday Holiday Holiday Holiday

I am new to crosstab queries and tried to do one of these to diplay the
info
but couldn't get it to work as the details I want displayed (audit, dealer
no, etc) are the values of fields rather than a calculation. Can anyone
advise me how to produce a simple report displaying the data in this
format?
I will add a start and end date filter to a form to display which week I
want
printed, I am just not sure how to get a report in this layout?

Thanks in advance for any help.
Sue

As detailed in my previous message I don't think a crosstab query will work
and wanted clarification of this and any advice on how I could maybe achieve
it? A crosstab query does produce the format of names in rows and dates as
column headings but the trouble is the text to be displayed is not a 'count'
or 'sum' of anything. I literally just want to display the contents of a few
fields as per my previous example, showing what activity each person is doing
and a dealer number if they were on an audit, on a daily basis per week range.

"Duane Hookom" wrote:

If the calendar reports don't work for you then try look at the crosstab
reports at http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

--
Duane Hookom
MS Access MVP
--


"hughess7" wrote in message
...
Hi, I would like a report which prints out a weekly itinerary plan for our
employees. I have looked at Duane Hookom's reports but they don't quite
achieve what I want and not too sure how to replicate something similar. I
want a layout like below:

Mon Tues Wed Thurs Frid
3 4 5 6 7
Fred Bloggs Audit Meeting Travel Audit Office
1234 4567
Jane Doe Audit Audit Audit Audit Audit
9876 9876 9876 9876 9876
Bilbo Baggins Holiday Holiday Holiday Holiday Holiday

I am new to crosstab queries and tried to do one of these to diplay the
info
but couldn't get it to work as the details I want displayed (audit, dealer
no, etc) are the values of fields rather than a calculation. Can anyone
advise me how to produce a simple report displaying the data in this
format?
I will add a start and end date filter to a form to display which week I
want
printed, I am just not sure how to get a report in this layout?

Thanks in advance for any help.
Sue

You don't have to use count or sum. You can use First or Max or Min with a
Value expression like:
colhead:[Audit] & Chr(13) & chr(10) & [DealerNo]

--
Duane Hookom
MS Access MVP
--

"hughess7" wrote in message
...
As detailed in my previous message I don't think a crosstab query will
work
and wanted clarification of this and any advice on how I could maybe
achieve
it? A crosstab query does produce the format of names in rows and dates as
column headings but the trouble is the text to be displayed is not a
'count'
or 'sum' of anything. I literally just want to display the contents of a
few
fields as per my previous example, showing what activity each person is
doing
and a dealer number if they were on an audit, on a daily basis per week
range.

"Duane Hookom" wrote:

If the calendar reports don't work for you then try look at the crosstab
reports at http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

--
Duane Hookom
MS Access MVP
--


"hughess7" wrote in message
...
Hi, I would like a report which prints out a weekly itinerary plan for
our
employees. I have looked at Duane Hookom's reports but they don't quite
achieve what I want and not too sure how to replicate something
similar. I
want a layout like below:

Mon Tues Wed Thurs Frid
3 4 5 6 7
Fred Bloggs Audit Meeting Travel Audit Office
1234 4567
Jane Doe Audit Audit Audit Audit Audit
9876 9876 9876 9876 9876
Bilbo Baggins Holiday Holiday Holiday Holiday Holiday

I am new to crosstab queries and tried to do one of these to diplay the
info
but couldn't get it to work as the details I want displayed (audit,
dealer
no, etc) are the values of fields rather than a calculation. Can anyone
advise me how to produce a simple report displaying the data in this
format?
I will add a start and end date filter to a form to display which week
I
want
printed, I am just not sure how to get a report in this layout?

Thanks in advance for any help.
Sue

I have a scheduling calendar module that I developed that will do what you
need. Send me your email address to my email address below and I will send
you a screen shot of what I have.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"hughess7" wrote in message
...
As detailed in my previous message I don't think a crosstab query will
work
and wanted clarification of this and any advice on how I could maybe
achieve
it? A crosstab query does produce the format of names in rows and dates as
column headings but the trouble is the text to be displayed is not a
'count'
or 'sum' of anything. I literally just want to display the contents of a
few
fields as per my previous example, showing what activity each person is
doing
and a dealer number if they were on an audit, on a daily basis per week
range.

"Duane Hookom" wrote:

If the calendar reports don't work for you then try look at the crosstab
reports at http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

--
Duane Hookom
MS Access MVP
--


"hughess7" wrote in message
...
Hi, I would like a report which prints out a weekly itinerary plan for
our
employees. I have looked at Duane Hookom's reports but they don't
quite
achieve what I want and not too sure how to replicate something
similar. I
want a layout like below:

Mon Tues Wed Thurs Frid
3 4 5 6
7
Fred Bloggs Audit Meeting Travel Audit Office
1234 4567
Jane Doe Audit Audit Audit Audit Audit
9876 9876 9876 9876 9876
Bilbo Baggins Holiday Holiday Holiday Holiday Holiday

I am new to crosstab queries and tried to do one of these to diplay
the
info
but couldn't get it to work as the details I want displayed (audit,
dealer
no, etc) are the values of fields rather than a calculation. Can
anyone
advise me how to produce a simple report displaying the data in this
format?
I will add a start and end date filter to a form to display which week
I
want
printed, I am just not sure how to get a report in this layout?

Thanks in advance for any help.
Sue

Yes but that still doesn't achieve what I want, I used Count as an example
sorry - I know you can use Min/Max etc but I don't want to evaluate text I
just want the value stored in a field displayed. If I use something similar
to your example I get a single record per specialist showing the first (or
last if Max) date
that the specialist carried out each activity. Whereas I want a record
displayed for every date showing what each specialist was doing that day as
per my illustrative example ie I want the Dates as column headings (showing
one weeks worth Mon - Frid) and the Specialist as Row Headings and the values
displayed being what activity they were doing (plus values from other fields
if they were on an audit).

Hope this makes sense more?
Thanks

"Duane Hookom" wrote:

You don't have to use count or sum. You can use First or Max or Min with a
Value expression like:
colhead:[Audit] & Chr(13) & chr(10) & [DealerNo]

--
Duane Hookom
MS Access MVP
--

"hughess7" wrote in message
...
As detailed in my previous message I don't think a crosstab query will
work
and wanted clarification of this and any advice on how I could maybe
achieve
it? A crosstab query does produce the format of names in rows and dates as
column headings but the trouble is the text to be displayed is not a
'count'
or 'sum' of anything. I literally just want to display the contents of a
few
fields as per my previous example, showing what activity each person is
doing
and a dealer number if they were on an audit, on a daily basis per week
range.

"Duane Hookom" wrote:

If the calendar reports don't work for you then try look at the crosstab
reports at http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

--
Duane Hookom
MS Access MVP
--


"hughess7" wrote in message
...
Hi, I would like a report which prints out a weekly itinerary plan for
our
employees. I have looked at Duane Hookom's reports but they don't quite
achieve what I want and not too sure how to replicate something
similar. I
want a layout like below:

Mon Tues Wed Thurs Frid
3 4 5 6 7
Fred Bloggs Audit Meeting Travel Audit Office
1234 4567
Jane Doe Audit Audit Audit Audit Audit
9876 9876 9876 9876 9876
Bilbo Baggins Holiday Holiday Holiday Holiday Holiday

I am new to crosstab queries and tried to do one of these to diplay the
info
but couldn't get it to work as the details I want displayed (audit,
dealer
no, etc) are the values of fields rather than a calculation. Can anyone
advise me how to produce a simple report displaying the data in this
format?
I will add a start and end date filter to a form to display which week
I
want
printed, I am just not sure how to get a report in this layout?

Thanks in advance for any help.
Sue

Thanks I know, we have emailed before. I want help/advice on how to do it
myself though so I can learn more... thanks anyway :-)

"PC Datasheet" wrote:

I have a scheduling calendar module that I developed that will do what you
need. Send me your email address to my email address below and I will send
you a screen shot of what I have.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"hughess7" wrote in message
...
As detailed in my previous message I don't think a crosstab query will
work
and wanted clarification of this and any advice on how I could maybe
achieve
it? A crosstab query does produce the format of names in rows and dates as
column headings but the trouble is the text to be displayed is not a
'count'
or 'sum' of anything. I literally just want to display the contents of a
few
fields as per my previous example, showing what activity each person is
doing
and a dealer number if they were on an audit, on a daily basis per week
range.

"Duane Hookom" wrote:

If the calendar reports don't work for you then try look at the crosstab
reports at http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

--
Duane Hookom
MS Access MVP
--


"hughess7" wrote in message
...
Hi, I would like a report which prints out a weekly itinerary plan for
our
employees. I have looked at Duane Hookom's reports but they don't
quite
achieve what I want and not too sure how to replicate something
similar. I
want a layout like below:

Mon Tues Wed Thurs Frid
3 4 5 6
7
Fred Bloggs Audit Meeting Travel Audit Office
1234 4567
Jane Doe Audit Audit Audit Audit Audit
9876 9876 9876 9876 9876
Bilbo Baggins Holiday Holiday Holiday Holiday Holiday

I am new to crosstab queries and tried to do one of these to diplay
the
info
but couldn't get it to work as the details I want displayed (audit,
dealer
no, etc) are the values of fields rather than a calculation. Can
anyone
advise me how to produce a simple report displaying the data in this
format?
I will add a start and end date filter to a form to display which week
I
want
printed, I am just not sure how to get a report in this layout?

Thanks in advance for any help.
Sue

sorry... just done some more work on this and it DOES achieve what I want
:-). The reason I thought it didn't was because the crosstab query was based
on another query (which had linked tables to produce the specialists name and
activity desc instead of the short codes/IDs). When I created a new crosstab
query from scratch based directly on the table it produced the results I
wanted using the Min function. Now I just have to make it display descriptive
text instead of primary key values eg audit instead of AU ...etc...
Thanks

"hughess7" wrote:

Yes but that still doesn't achieve what I want, I used Count as an example
sorry - I know you can use Min/Max etc but I don't want to evaluate text I
just want the value stored in a field displayed. If I use something similar
to your example I get a single record per specialist showing the first (or
last if Max) date
that the specialist carried out each activity. Whereas I want a record
displayed for every date showing what each specialist was doing that day as
per my illustrative example ie I want the Dates as column headings (showing
one weeks worth Mon - Frid) and the Specialist as Row Headings and the values
displayed being what activity they were doing (plus values from other fields
if they were on an audit).

Hope this makes sense more?
Thanks

"Duane Hookom" wrote:

You don't have to use count or sum. You can use First or Max or Min with a
Value expression like:
colhead:[Audit] & Chr(13) & chr(10) & [DealerNo]

--
Duane Hookom
MS Access MVP
--

"hughess7" wrote in message
...
As detailed in my previous message I don't think a crosstab query will
work
and wanted clarification of this and any advice on how I could maybe
achieve
it? A crosstab query does produce the format of names in rows and dates as
column headings but the trouble is the text to be displayed is not a
'count'
or 'sum' of anything. I literally just want to display the contents of a
few
fields as per my previous example, showing what activity each person is
doing
and a dealer number if they were on an audit, on a daily basis per week
range.

"Duane Hookom" wrote:

If the calendar reports don't work for you then try look at the crosstab
reports at http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

--
Duane Hookom
MS Access MVP
--


"hughess7" wrote in message
...
Hi, I would like a report which prints out a weekly itinerary plan for
our
employees. I have looked at Duane Hookom's reports but they don't quite
achieve what I want and not too sure how to replicate something
similar. I
want a layout like below:

Mon Tues Wed Thurs Frid
3 4 5 6 7
Fred Bloggs Audit Meeting Travel Audit Office
1234 4567
Jane Doe Audit Audit Audit Audit Audit
9876 9876 9876 9876 9876
Bilbo Baggins Holiday Holiday Holiday Holiday Holiday

I am new to crosstab queries and tried to do one of these to diplay the
info
but couldn't get it to work as the details I want displayed (audit,
dealer
no, etc) are the values of fields rather than a calculation. Can anyone
advise me how to produce a simple report displaying the data in this
format?
I will add a start and end date filter to a form to display which week
I
want
printed, I am just not sure how to get a report in this layout?

Thanks in advance for any help.
Sue

This is great and it works for me also. Just one more question -- can you
format the values within the crosstab? For my crosstab query, I use the
expression

Expr1: First([Description] & Chr(13) & Chr(10) & [Sales - Y1] & Chr(13) &
Chr(10) & Left([Project Name],20))

to find the value for each row/column intersection. Now, when I create the
report, I want to format the [Sales - Y1] fied to currency with no decimal
places.

Any ideas?

thanks in advance
"Duane Hookom" wrote:

You don't have to use count or sum. You can use First or Max or Min with a
Value expression like:
colhead:[Audit] & Chr(13) & chr(10) & [DealerNo]

--
Duane Hookom
MS Access MVP
--

"hughess7" wrote in message
...
As detailed in my previous message I don't think a crosstab query will
work
and wanted clarification of this and any advice on how I could maybe
achieve
it? A crosstab query does produce the format of names in rows and dates as
column headings but the trouble is the text to be displayed is not a
'count'
or 'sum' of anything. I literally just want to display the contents of a
few
fields as per my previous example, showing what activity each person is
doing
and a dealer number if they were on an audit, on a daily basis per week
range.

"Duane Hookom" wrote:

If the calendar reports don't work for you then try look at the crosstab
reports at http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

--
Duane Hookom
MS Access MVP
--


"hughess7" wrote in message
...
Hi, I would like a report which prints out a weekly itinerary plan for
our
employees. I have looked at Duane Hookom's reports but they don't quite
achieve what I want and not too sure how to replicate something
similar. I
want a layout like below:

Mon Tues Wed Thurs Frid
3 4 5 6 7
Fred Bloggs Audit Meeting Travel Audit Office
1234 4567
Jane Doe Audit Audit Audit Audit Audit
9876 9876 9876 9876 9876
Bilbo Baggins Holiday Holiday Holiday Holiday Holiday

I am new to crosstab queries and tried to do one of these to diplay the
info
but couldn't get it to work as the details I want displayed (audit,
dealer
no, etc) are the values of fields rather than a calculation. Can anyone
advise me how to produce a simple report displaying the data in this
format?
I will add a start and end date filter to a form to display which week
I
want
printed, I am just not sure how to get a report in this layout?

Thanks in advance for any help.
Sue

You can try:
Expr1: First([Description] & Chr(13) & Chr(10) & Format([Sales - Y1],"$0") &
Chr(13) &
Chr(10) & Left([Project Name],20))


--
Duane Hookom
MS Access MVP


"tom at arundel" wrote in message
...
This is great and it works for me also. Just one more question -- can you
format the values within the crosstab? For my crosstab query, I use the
expression

Expr1: First([Description] & Chr(13) & Chr(10) & [Sales - Y1] & Chr(13) &
Chr(10) & Left([Project Name],20))

to find the value for each row/column intersection. Now, when I create
the
report, I want to format the [Sales - Y1] fied to currency with no decimal
places.

Any ideas?

thanks in advance
"Duane Hookom" wrote:

You don't have to use count or sum. You can use First or Max or Min with
a
Value expression like:
colhead:[Audit] & Chr(13) & chr(10) & [DealerNo]

--
Duane Hookom
MS Access MVP
--

"hughess7" wrote in message
...
As detailed in my previous message I don't think a crosstab query will
work
and wanted clarification of this and any advice on how I could maybe
achieve
it? A crosstab query does produce the format of names in rows and dates
as
column headings but the trouble is the text to be displayed is not a
'count'
or 'sum' of anything. I literally just want to display the contents of
a
few
fields as per my previous example, showing what activity each person is
doing
and a dealer number if they were on an audit, on a daily basis per week
range.

"Duane Hookom" wrote:

If the calendar reports don't work for you then try look at the
crosstab
reports at http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

--
Duane Hookom
MS Access MVP
--


"hughess7" wrote in message
...
Hi, I would like a report which prints out a weekly itinerary plan
for
our
employees. I have looked at Duane Hookom's reports but they don't
quite
achieve what I want and not too sure how to replicate something
similar. I
want a layout like below:

Mon Tues Wed Thurs Frid
3 4 5 6
7
Fred Bloggs Audit Meeting Travel Audit Office
1234 4567
Jane Doe Audit Audit Audit Audit Audit
9876 9876 9876 9876 9876
Bilbo Baggins Holiday Holiday Holiday Holiday Holiday

I am new to crosstab queries and tried to do one of these to diplay
the
info
but couldn't get it to work as the details I want displayed (audit,
dealer
no, etc) are the values of fields rather than a calculation. Can
anyone
advise me how to produce a simple report displaying the data in this
format?
I will add a start and end date filter to a form to display which
week
I
want
printed, I am just not sure how to get a report in this layout?

Thanks in advance for any help.
Sue