Do you mean...

SELECT
T.*
FROM
Tenders T
WHERE
(T.Date_Closing IS NULL)
or (T.Value IS NULL)
or ((T.Date_Closing BETWEEN DateA and DateB) and (T.Value IS NULL))

On Wed, Oct 17, 2012 at 7:47 AM, Nols Smit <nols@...> wrote:

> **
>
>
> Hi,
>
> I have a table, let's call it TENDERS. It has the following fields: ID,
> Date_Closing, Value (ID is the pimary key).
>
> How do I select the the records in TENDERS where either Date_Closing or
> Value or both is null but also including those records where Date_Closing
> is not null and Date_Closing is between DateA and DateB and Value is null ?
>
> Regards,
>
> Nols Smit
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]