How can I create a calendar report in access

[Guest]

I am a very limited in my ablity on access and all the terms. I want to
create a report to look like a calendar from my table. I would like to sort
it by Month & associate. I just don't know how to get the dates to lay out
like a calendar with the days of the week going across. I have created a
report with this info displayed in rows but not columns or calendar view. I
would like it to look something like this:
September Monday 1 Tuesday 2
Wednesday 3
Ann Smith Belk #23, Oak Park, FFTC Bloomies #3, NY, FFTC Belk
#1, NY,

Monday 8 Tuesday 9
Nordstrom #43 LA, FFTC Macy's #2, San Fran, FFTC

 

[Duane Hookom]

There are some sample calendar style reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

Come on back if you have any questions about these.

 

[Guest]

One of the samples are exactly what I am looking to create. But with my
limited abilities with access and especially formulas, I can not figure how
to re-create what I saw without seeing their table. Their formulas don't
work for me. I think I might need a tutorial on creating calendars. Is
there such a thing?

 

[Duane Hookom]

I am not aware of any tutorials for this specific type of report. You can
come back here with specific questions. Make sure you tell us which sample
you are using.

 

[Guest]

I was looking at the Calendar style schedule (the last sample).
My table field names consist of:
Consultant name
RCC name
Store name
FFTC day
FFTC date
FFTC time
and many other items, but thise are how I want to sort. I noticed that on
the sample, for a control souce he had =[WeekOf]+1. I tried adding the first
day of the week to my fields but that did not report them correctly & I also
added week #'s which did not help. I think I am just looking for the
calculation in the control source that will report my days of the week so
they will column out like the last sample.
Is there anything else I can tell you to maybe explain better.

 

[Duane Hookom]

Your main report should have a totals query as the record source that groups
by
WeekOf: DateAdd("d",-Weekday([FFTC date]),[FFTC date])+1
This create the WeekOf values.

If you want separate calendars for each value of RCCName or Store, you will
need to add this field to your main report's record source.

--
Duane Hookom
MS Access MVP
--

I was looking at the Calendar style schedule (the last sample).
My table field names consist of:
Consultant name
RCC name
Store name
FFTC day
FFTC date
FFTC time
and many other items, but thise are how I want to sort. I noticed that on
the sample, for a control souce he had =[WeekOf]+1. I tried adding the
first
day of the week to my fields but that did not report them correctly & I
also
added week #'s which did not help. I think I am just looking for the
calculation in the control source that will report my days of the week so
they will column out like the last sample.
Is there anything else I can tell you to maybe explain better.

I am not aware of any tutorials for this specific type of report. You can
come back here with specific questions. Make sure you tell us which
sample
you are using.

 

[Guest]

Leave your email address and I will send you a screenshot of what I have.

 

[Guest]

I am sorry but I am a beginner to access. You are saying that I need a query
to run my report. I understand that. But the calculation that you wrote
does not work in that query or the report. I wrote the calculation just as
you did & I get error reports. Is there anyway you can explain it for a
beginner. I guess I really need it spelled out for me.
(e-mail address removed)

Your main report should have a totals query as the record source that groups
by
WeekOf: DateAdd("d",-Weekday([FFTC date]),[FFTC date])+1
This create the WeekOf values.

If you want separate calendars for each value of RCCName or Store, you will
need to add this field to your main report's record source.

--
Duane Hookom
MS Access MVP
--

I was looking at the Calendar style schedule (the last sample).
My table field names consist of:
Consultant name
RCC name
Store name
FFTC day
FFTC date
FFTC time
and many other items, but thise are how I want to sort. I noticed that on
the sample, for a control souce he had =[WeekOf]+1. I tried adding the
first
day of the week to my fields but that did not report them correctly & I
also
added week #'s which did not help. I think I am just looking for the
calculation in the control source that will report my days of the week so
they will column out like the last sample.
Is there anything else I can tell you to maybe explain better.

I am not aware of any tutorials for this specific type of report. You can
come back here with specific questions. Make sure you tell us which
sample
you are using.

--
Duane Hookom
MS Access MVP


One of the samples are exactly what I am looking to create. But with
my
limited abilities with access and especially formulas, I can not figure
how
to re-create what I saw without seeing their table. Their formulas
don't
work for me. I think I might need a tutorial on creating calendars.
Is
there such a thing?

:

There are some sample calendar style reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

Come on back if you have any questions about these.

--
Duane Hookom
MS Access MVP
--

I am a very limited in my ablity on access and all the terms. I want
to
create a report to look like a calendar from my table. I would like
to
sort
it by Month & associate. I just don't know how to get the dates to
lay
out
like a calendar with the days of the week going across. I have
created
a
report with this info displayed in rows but not columns or calendar
view.
I
would like it to look something like this:
September Monday 1 Tuesday 2
Wednesday 3
Ann Smith Belk #23, Oak Park, FFTC Bloomies #3, NY, FFTC
Belk
#1, NY,

Monday 8 Tuesday 9
Nordstrom #43 LA, FFTC Macy's #2, San Fran,
FFTC

 

[Duane Hookom]

I believe the record source of the main report should be something like:

SELECT [RCC name], DateAdd("d",-Weekday([FFTC date]),[FFTC date])+1 as
WeekOf
FROM tblMyTable
GROUP BY [RCC name], DateAdd("d",-Weekday([FFTC date]),[FFTC date])+1;

It isn't clear whether the calendar includes all RCC names and Stores in the
same pages or are they supposed to be on their own.

--
Duane Hookom
MS Access MVP
--

I am sorry but I am a beginner to access. You are saying that I need a
query
to run my report. I understand that. But the calculation that you wrote
does not work in that query or the report. I wrote the calculation just
as
you did & I get error reports. Is there anyway you can explain it for a
beginner. I guess I really need it spelled out for me.
(e-mail address removed)

Your main report should have a totals query as the record source that
groups
by
WeekOf: DateAdd("d",-Weekday([FFTC date]),[FFTC date])+1
This create the WeekOf values.

If you want separate calendars for each value of RCCName or Store, you
will
need to add this field to your main report's record source.

--
Duane Hookom
MS Access MVP
--

I was looking at the Calendar style schedule (the last sample).
My table field names consist of:
Consultant name
RCC name
Store name
FFTC day
FFTC date
FFTC time
and many other items, but thise are how I want to sort. I noticed that
on
the sample, for a control souce he had =[WeekOf]+1. I tried adding the
first
day of the week to my fields but that did not report them correctly & I
also
added week #'s which did not help. I think I am just looking for the
calculation in the control source that will report my days of the week
so
they will column out like the last sample.
Is there anything else I can tell you to maybe explain better.

:

I am not aware of any tutorials for this specific type of report. You
can
come back here with specific questions. Make sure you tell us which
sample
you are using.

--
Duane Hookom
MS Access MVP


One of the samples are exactly what I am looking to create. But
with
my
limited abilities with access and especially formulas, I can not
figure
how
to re-create what I saw without seeing their table. Their formulas
don't
work for me. I think I might need a tutorial on creating calendars.
Is
there such a thing?

:

There are some sample calendar style reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

Come on back if you have any questions about these.

--
Duane Hookom
MS Access MVP
--

I am a very limited in my ablity on access and all the terms. I
want
to
create a report to look like a calendar from my table. I would
like
to
sort
it by Month & associate. I just don't know how to get the dates
to
lay
out
like a calendar with the days of the week going across. I have
created
a
report with this info displayed in rows but not columns or
calendar
view.
I
would like it to look something like this:
September Monday 1 Tuesday 2
Wednesday 3
Ann Smith Belk #23, Oak Park, FFTC Bloomies #3, NY, FFTC
Belk
#1, NY,

Monday 8 Tuesday
9
Nordstrom #43 LA, FFTC Macy's #2, San
Fran,
FFTC