Diary query Help!

[Derek Brown]

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

 

[Duane Hookom]

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.

 

[Derek Brown]

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

--
Duane Hookom
MS Access MVP

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