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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |