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