I need it to include all records, whether or not they have a date. If a date field is null it still needs to show. But a date that is less than the current date should not show.
I read this to mean you want all records where a date field is null AND all records where the date field is greater than the current date.
I used a test dB and came up with:
Code:
SELECT fDates.FFYBeginDate, fDates.FFYEndDate
FROM fDates
WHERE (fDates.FFYEndDate > Date()) OR (fDates.FFYEndDate Is Null);
FFYEndDate MUST be a Date/Time field!
Change table.fieldnames to your names.