Hello - I'm trying to create a field in my query that will do the following:

Evaluate whether the Inactive Date field is either blank or has dates between: 7/1/12 and 7/31/12 and return the words "use for calculation"


The Inactive Date field in my table has blanks or sometimes it has dates. I'm concerned only with blank date fields and fields with dates that occur this month (July 2012).

I've been trying countless IIf formulas but I can't get it work correctly. I'm using Access 2000.

Thanks.

CheckDate: IIF(IsNull(Inactive),"use for calculation",IIF(Inactive>=#7/1/12# AND Inactive<=#7/31/12#,"use for calculation",Don't use))

That should work.

CheckDate: IIF(IsNull(Inactive),"use for calculation",IIF(Inactive>=#7/1/12# AND Inactive<=#7/31/12#,"use for calculation",Don't use))

That should work.

Awesome... thx, man... got it to work

Welcome