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