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]