SteveL13
asked on
How calculate field on a report
On a repost I have 4 fields. They are:
ShipDate (date field)
ReschDate (date field)
LastDateShpd (date field)
OnTime (text field)
There are different scenarios that need to be examined.
1) If LastDateShpd and ReschDate are not null and ReschDate > LastDateShpd then OnTime has to be "N"
2) If ReschDate is null and ShipDate > LastDateShpd then OnTime has to be "N"
3) If ReschDate is null and ShipDate <= LastDateShpd then OnTime has to be "Y"
How would I code the onprint event of the detail section of the form? Note that OnTime is not a bound field
ShipDate (date field)
ReschDate (date field)
LastDateShpd (date field)
OnTime (text field)
There are different scenarios that need to be examined.
1) If LastDateShpd and ReschDate are not null and ReschDate > LastDateShpd then OnTime has to be "N"
2) If ReschDate is null and ShipDate > LastDateShpd then OnTime has to be "N"
3) If ReschDate is null and ShipDate <= LastDateShpd then OnTime has to be "Y"
How would I code the onprint event of the detail section of the form? Note that OnTime is not a bound field
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER