Query Question for Access
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.