darthanian
New Member
- Joined
- May 4, 2016
- Messages
- 1
Hi all,
I've been reading this board long time and it's helped a great deal on other subjects. I could not find a reference for this. Never been much good with regular expressions, more of a hardware guy.
As of now my repair shop uses a MS Access database to track my tech's times per work order. I'm not sure if the previous person who set this up simply found this form online or designed it, i'm thinking the former. As of now when we enter "OUT" into the work order field it takes that time minus his total time in a day. So he worked worked 7 hours and 1 hour of OUT. Would show accordingly. Well management wants me to be more specific about what kind of "out" time it is. So now instead of using out we want to use this format options. Year, Employee#, PTO/Sick. So the work order will be 165555P for a pto time allotment. Looking for options. It needs to subtract from time worked, and either add to the "OUT" field or i was thinking i might need to add another field..
Here are the current expressions calculating the time
=HoursAndMinutes(Sum(IIf([Job No]="Out",([out]-[in]),0)))+" Hrs. Out"
=HoursAndMinutes(Sum(IIf([Job No]<>"Out",([out]-[in]))))+" Hrs."
I've been reading this board long time and it's helped a great deal on other subjects. I could not find a reference for this. Never been much good with regular expressions, more of a hardware guy.
As of now my repair shop uses a MS Access database to track my tech's times per work order. I'm not sure if the previous person who set this up simply found this form online or designed it, i'm thinking the former. As of now when we enter "OUT" into the work order field it takes that time minus his total time in a day. So he worked worked 7 hours and 1 hour of OUT. Would show accordingly. Well management wants me to be more specific about what kind of "out" time it is. So now instead of using out we want to use this format options. Year, Employee#, PTO/Sick. So the work order will be 165555P for a pto time allotment. Looking for options. It needs to subtract from time worked, and either add to the "OUT" field or i was thinking i might need to add another field..
Here are the current expressions calculating the time
=HoursAndMinutes(Sum(IIf([Job No]="Out",([out]-[in]),0)))+" Hrs. Out"
=HoursAndMinutes(Sum(IIf([Job No]<>"Out",([out]-[in]))))+" Hrs."