all4jcvette
Registered User.
- Local time
- Today, 06:21
- Joined
- Jun 12, 2009
- Messages
- 10
I have a complex if/and/or calculation formula in Excel that I want to convert into a query for access. The field names in Excel and Access are the same "effective_date" and "inactive_date". The new column is named "status_type". I've tried all kinds of conversion, and I just can't figure it out. Any help would be appreciated.
Excel Formula:
=IF((AND([effective_date]="",[inactive_date]="")),"Pending Approval",IF((AND([effective_date]<=TODAY(),OR([inactive_date]>=TODAY(),[inactive_date]=""))),"Active Enforcement",IF((AND([effective_date]>=TODAY(),[inactive_date]>="")),"Future Enforcement","Inactive")))
Excel Formula:
=IF((AND([effective_date]="",[inactive_date]="")),"Pending Approval",IF((AND([effective_date]<=TODAY(),OR([inactive_date]>=TODAY(),[inactive_date]=""))),"Active Enforcement",IF((AND([effective_date]>=TODAY(),[inactive_date]>="")),"Future Enforcement","Inactive")))