A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Calender Report



 
 
Thread Tools Display Modes
  #1  
Old July 15th, 2004, 03:22 PM
external usenet poster
 
Posts: n/a
Default Calender Report

I'm trying to create a calender report (will look like a
calender) using http://www.invisibleinc.com/divFiles.cfm?
divDivID=4. I've run into a couple of issues. I THOUGHT
I had everything set up the same as the file from
invisible inc but when I preview the report I have
duplicate data running through the report - it seems to be
repeating the same weeks over and over again. The second
issue I have is that I need to break the dates on seperate
pages for each month. I will also have dates running into
the next year so I cannot just break on month alone (i.e.
the week of Jan 1 this year included M-Wed in 2003 and T-
Fri were 2004. Has anyone run into this before? Thanks.

  #2  
Old July 15th, 2004, 08:24 PM
Duane Hookom
external usenet poster
 
Posts: n/a
Default Calender Report

Hi anonymous,
I created the original report so have a little knowledge of it. If you have
repeating weeks, check the record source of your main report. It should
contain a single record for each week. I expect your query returns several
records per week.

After you fix this, reply back in this thread if you have additional
questions.

--
Duane Hookom
MS Access MVP
--

wrote in message
...
I'm trying to create a calender report (will look like a
calender) using http://www.invisibleinc.com/divFiles.cfm?
divDivID=4. I've run into a couple of issues. I THOUGHT
I had everything set up the same as the file from
invisible inc but when I preview the report I have
duplicate data running through the report - it seems to be
repeating the same weeks over and over again. The second
issue I have is that I need to break the dates on seperate
pages for each month. I will also have dates running into
the next year so I cannot just break on month alone (i.e.
the week of Jan 1 this year included M-Wed in 2003 and T-
Fri were 2004. Has anyone run into this before? Thanks.



  #3  
Old July 15th, 2004, 10:48 PM
external usenet poster
 
Posts: n/a
Default Calender Report

Hi, I straightened out the duplicate data - thanks for
that one. I still have issues though - the weeks are not
in order by date (week of 6/21 comes before week of 5/21
even though it's the same year). The other part of the
issue is that I need a page break by month and if it's at
the beginning or end of the year and the week is running
in two seperate years (i.e. the first half of the week of
1/1 was dec. 2003 and the other half was jan 2004) I
would also need to break by year. Thanks in advance for
any advice.

-----Original Message-----
Hi anonymous,
I created the original report so have a little knowledge

of it. If you have
repeating weeks, check the record source of your main

report. It should
contain a single record for each week. I expect your

query returns several
records per week.

After you fix this, reply back in this thread if you have

additional
questions.

--
Duane Hookom
MS Access MVP
--

wrote in message
...
I'm trying to create a calender report (will look like a
calender) using

http://www.invisibleinc.com/divFiles.cfm?
divDivID=4. I've run into a couple of issues. I

THOUGHT
I had everything set up the same as the file from
invisible inc but when I preview the report I have
duplicate data running through the report - it seems to

be
repeating the same weeks over and over again. The

second
issue I have is that I need to break the dates on

seperate
pages for each month. I will also have dates running

into
the next year so I cannot just break on month alone

(i.e.
the week of Jan 1 this year included M-Wed in 2003 and

T-
Fri were 2004. Has anyone run into this before?

Thanks.



.

  #4  
Old July 16th, 2004, 02:58 AM
Duane Hookom
external usenet poster
 
Posts: n/a
Default Calender Report

Your weekof calculation must be a valid date and the report must use this
WeekOf field in the sorting and grouping dialog. I you also want to separate
out by month, add a month field to the query the report is based on. Group
on this month and then the WeekOf field and set the report to break after
the month group.

--
Duane Hookom
MS Access MVP


wrote in message
...
Hi, I straightened out the duplicate data - thanks for
that one. I still have issues though - the weeks are not
in order by date (week of 6/21 comes before week of 5/21
even though it's the same year). The other part of the
issue is that I need a page break by month and if it's at
the beginning or end of the year and the week is running
in two seperate years (i.e. the first half of the week of
1/1 was dec. 2003 and the other half was jan 2004) I
would also need to break by year. Thanks in advance for
any advice.

-----Original Message-----
Hi anonymous,
I created the original report so have a little knowledge

of it. If you have
repeating weeks, check the record source of your main

report. It should
contain a single record for each week. I expect your

query returns several
records per week.

After you fix this, reply back in this thread if you have

additional
questions.

--
Duane Hookom
MS Access MVP
--

wrote in message
...
I'm trying to create a calender report (will look like a
calender) using

http://www.invisibleinc.com/divFiles.cfm?
divDivID=4. I've run into a couple of issues. I

THOUGHT
I had everything set up the same as the file from
invisible inc but when I preview the report I have
duplicate data running through the report - it seems to

be
repeating the same weeks over and over again. The

second
issue I have is that I need to break the dates on

seperate
pages for each month. I will also have dates running

into
the next year so I cannot just break on month alone

(i.e.
the week of Jan 1 this year included M-Wed in 2003 and

T-
Fri were 2004. Has anyone run into this before?

Thanks.



.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening reports causes report to open twice and produces errors Matt the confused newbie General Discussion 7 July 1st, 2004 09:32 PM
Specify Filter criteria before running report Nikos Yannacopoulos Setting Up & Running Reports 3 June 25th, 2004 09:36 PM
Label SRIT General Discussion 2 June 22nd, 2004 09:42 PM
need help make a report [email protected] General Discussion 2 June 16th, 2004 08:31 PM
Report button linked to exact report record- Open report method? Rich Using Forms 1 May 27th, 2004 06:17 PM


All times are GMT +1. The time now is 03:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.