Using multiple date fields for Date Range query

[glgcag]

I have a query that I need to add a date range criteria to. Here is how the criteria goes: if there is a date in the "DealMemoDate" field use it as criteria, if not, check the "PrelimReceived" field for a date and use it- if no date, check the "ContractFullyExecuted" field- if no date, skip the record altogether.

I appreciate the help!

 

[braindead2]

in the access QBE grid just type not null in the criteria under the first field then drop down a line and put it under the next field and down 1 more line under the next field

SQL will read
where([DealMemoDate])IS NOT Null or ([PrelimReceived])IS NOT Null or ([ContractFullyExecuted])IS NOT Null