Diary report Help!

[Derek Brown]

Hi all

I have a report that prints a diary of events. It makes available blank
space for days with no entries, that have just the days date heading. To do
this I have had to create 31 subreports(one for each month day) that filter
each days diary events and then put them all on one main report. It all
works great and supplies everything that I want except it takes 30 to 60
seconds to process and display.

There must be another way. Can I just emphasise that the problem with
sorting all the events into one report is that I cannot create a blank space
with just the date heading for days that have no records. I need this so
that the client can print a report take it out of the office and hand write
any new diary entries into the blank spaces.

Any genius out there?

 

[r. howell]

If you make sure that you have a blank event for each date you have in your
report, (ie, put in the date, with no time or event name), you can then get
away with a report that has one subreport in the detail field, tied to the
event date in the detail field.

Then make your detail field as big as you want it to be (extra blank space)
for the client.

Hope this is clear enough. I experimented, and got it to work. You should
be able to add those blank events with a query, but I didn't try to get
fancy.

 

[Derek Brown]

Hi r. howell Thank you.

If you could give me the vaguest direction of how to make a query produce
blank records I would be very grateful. This realy would solve a months
effort so far!

 

[r. howell]

I should probably apologize for trying to answer this, because I may have
delayed your getting a better answer. I'm in over my head. Here's a little
bit of information on calendars, that someone else compiled. If this doesn't
help, you may need to repost your question, since the chances are that the
big guns won't look at this, now that I posted a response. Good luck.

http://home.bendbroadband.com/conradsystems/accessjunkie/calendars.html

 

[Derek Brown]

Hi

Your responce has put me on the right track Or at learst a better one.
Thanks to your suggestion I created a table with a query and appended to
that table a list of 31days that are calculated by the start day of any
month + 1 to 31. I now have a table that has all of the appointments plus
one for every day just in case there are no appointments for that day. By
then hiding and filtering out the useless dates I have exacltly what I want.

Cheers!

 

[Derek Brown]

Hi "R. Howell"

Just thought that you may be interested in the ideal solution from Duane
Hookam:
--------------------------------------------------------------------------------
Create a table [tblNums] with a single numeric field [Num]. Then add
records with values 1 - 31. Use this table in your report's record source in
a way that would create all the dates of the month. Then plop one subreport
in the detail section of your report and it will print 31 times.

You can add a text box in the detail section that combines the month and
year with the [Num] field to produce a date value. Use this text box and the
date field from your subreport as the Link Master/Child properties.