?
_
I have created a DAP from a table I built. Often times people don't pay
attention to the end date so I was wondering is it possible to have a message
pop up stating whether or not the contract is expired based on a field? If
not, I assume I can do this in the table or the report itself? If so, what
would be the best route for accomplishing this? I am not that familiar with
Macros so I was thinking I could use a formula and I have
=IIf([End Date]<Date() And [Perpetual]="No","expired","current")
However, it isn't working as I would like. It's not reading the Perpetual
restriction. Can someone help? Thanks in advance
attention to the end date so I was wondering is it possible to have a message
pop up stating whether or not the contract is expired based on a field? If
not, I assume I can do this in the table or the report itself? If so, what
would be the best route for accomplishing this? I am not that familiar with
Macros so I was thinking I could use a formula and I have
=IIf([End Date]<Date() And [Perpetual]="No","expired","current")
However, it isn't working as I would like. It's not reading the Perpetual
restriction. Can someone help? Thanks in advance