Show a schedule of work

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

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)?

--
More info, please ...

Jeff Boyce
Access MVP

Yes!!!!!

Basically those records could show up once, twice or 10 times (depending how
long the piece of work is!)

Cheers


"Jeff Boyce" wrote:

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)?

--
More info, please ...

Jeff Boyce
Access MVP

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:
Date() or Is Null

--
Good luck

Jeff Boyce
Access MVP