Date query

[Jeff]

Hi

I'm trying to write a query that selects records based on a date range
and
Uses the Date of Birth if the Date entered is blank (null) or uses the
date entered if that date is filled in.

My query works fine for the first condition where I say if "date
entered is null" and DOB between the 2 dates.

My problem comes in when I put in the second line in the criteria and
say if the date entered is between the 2 dates.

Any help would be appreciated.

Thanks

Jeff

 

[Guest]

Post your SQL.