Show a schedule of work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)?
 
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:
 
Back
Top