How can I create a calendar report in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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?
 
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.
 
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.
 
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
--

bkrizman said:
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 said:
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.
Click to expand...
Click to expand...
 
Leave your email address and I will send you a screenshot of what I have.
 
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)

Duane Hookom said:
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
--

bkrizman said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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
--

bkrizman said:
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)

Duane Hookom said:
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
--

bkrizman said:
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
Click to expand...
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

report in access (Count) 1
Creating a Calendar Report 1
Concatenation in Reports 6
How to create a calendar report in access. 1
Access Report Calendar 10
Creating a weekly schedule with Calendar 5
Spreadsheet looks like a calendar 5
Creating reports from a Calendar 1

Back
Top