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]