Date Select Query

[paulS30berks]

I have set up a query that includes:

An assignment start date
An assignment end date

and in addition a column has been set up to show me a Start Date where Assignment End Dates are Null i.e all live assignments.

When I enter a date only results for that particular date are visible.

Can anyone suggest how i can expand this to include all live assignments?

Thanks

 

[Bat17]

Start Date Filter to <= Filterdate End date Filter to >= Filterdate OR Is Null

HTH

Peter