Access 2010 on Win 7 on a PC.
I built a form over a table that records 4 fields content in hours. The total of all 4 fields MUST total 24. Not more or less. So I'm trying to validate that all 4 numbers total 24, because I'm entering them from someone elses paper report, and I don't what to have to check his math. So in a glance I can see if my 4 entries total 24. I could even do a "Conditional format". I don't have to store the number in a table so I was trying an "unbound" text box. So why won't this work
=24-([tblLogBook]![SleeperBirth]+[tblLogBook]![Driving]+[tblLogBook]![OnDutyNot Driving]+[tblLogBook]![OffDuty])
nor will
=24-[tblLogBook]![SleeperBirth]-[tblLogBook]![Driving]-[tblLogBook]![OnDutyNot Driving]-[tblLogBook]![OffDuty]:banghead:
I built a form over a table that records 4 fields content in hours. The total of all 4 fields MUST total 24. Not more or less. So I'm trying to validate that all 4 numbers total 24, because I'm entering them from someone elses paper report, and I don't what to have to check his math. So in a glance I can see if my 4 entries total 24. I could even do a "Conditional format". I don't have to store the number in a table so I was trying an "unbound" text box. So why won't this work
=24-([tblLogBook]![SleeperBirth]+[tblLogBook]![Driving]+[tblLogBook]![OnDutyNot Driving]+[tblLogBook]![OffDuty])
nor will
=24-[tblLogBook]![SleeperBirth]-[tblLogBook]![Driving]-[tblLogBook]![OnDutyNot Driving]-[tblLogBook]![OffDuty]:banghead:
