Show a schedule of work

D

Des King

OK. This is probably very simple but I am struggling to manage it this morning!

I am trying to create a schedule of work. I have a table which contains a
start and an end date to a pieces of work. I have managed to set up the
report grouped by the start date, but this will only shows work that is due
to start that day, what I want is to also show any of those records that are
still ongoing (ie run over a couple of days) - So those records show up on
all the days from their Start to End

There is probably something I need to write in SQL but its beyond me this
morning.

Any help would be greatly appreciated.
 
J

Jeff Boyce

Are you saying you want to select those rows where you've already passed the
start date, and for which the end date is still in the future or is null
(hasn't happened yet, if at all)?
 
J

Jeff Boyce

Des

Create a query. Include the table and fields in question.

Under the criterion for the StartDate, use something like:
<Date()

Under the criterion for the EndDate use something like:
 
Top