Diary query Help!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Derek Brown - 11 Nov 2005 10:45 GMT

Hi all

I have a month diary report that prints a diary of events. It makes
available blank
space for days with no entries so that the user can hand write in events
while away from the office, 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.

What I really would like is to somehow produce a query or table that has the
date of a day where there are no records or diary events. Is it possible to
create a query that produces a record (albeit with just the date) when for
example there are no diary events between 11th Nov (See Auntie Jean) and 13
Nov(Buy some Headache Pills) that creates a record that just produces a date
i.e. 12Nov

Reply to this Message

Duane Hookom - 11 Nov 2005 13:46 GMT

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

Signature

Duane Hookom
MS Access MVP

> Hi all
>
[quoted text clipped - 14 lines]
> Auntie Jean) and 13 Nov(Buy some Headache Pills) that creates a record
> that just produces a date i.e. 12Nov

Reply to this Message

Derek Brown - 11 Nov 2005 21:25 GMT

Hi Duane

That works a treat!!

Thank you.

>I would 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
[quoted text clipped - 23 lines]
>> Auntie Jean) and 13 Nov(Buy some Headache Pills) that creates a record
>> that just produces a date i.e. 12Nov

Reply to this Message