Here's my report layout:
FOR ALL EMPLOYEES
EDIT LIST: 10 BATCH: TIME
CHK TR JOB/ PH/ COST CD/ ST/ SU DBLWC TRD UNION/ SK LEV/ COMP/ REIMB AMT/ -
DATE CERT DAYS EEO LOC ST ST ST BNK SUPER LAB CAT EARN REIMB ACCT REG OVT DBL RATE
12345 EMPLOYEE, JOE A. GRP: HOME ST/LOC: CA/ / / ST/LOC: 1/1/ / SUTA/DBL/WC: E/E/E
DIR DEP: N
1 1 12.345 N4 20HHW CA CA CA CA OP SOCALPT 5THYAP 5187X 0.00 16.00 2.00 0.00 23.2300 929.20
10/07/05 Y 0.00 AP FE PI HR 15040
SAT SUN MON TUE WED THR FRI
R: 0.00 0.00 0.00 0.00 0.00 8.00 8.00
O: 0.00 0.00 0.00 2.00 0.00 0.00 0.00
2 12.345 99 0002 CA CA CA CA OP SOCALPT 5THYAP 5187X 10.50 10.00 0.00 0.00 23.2300 0.00
10/07/05 Y 0.00 AP FE PI HR 15040 /font[/quote]my detail trap is on the hours (R:[/b]), trap characters: ßÃ:ß[/b]
In the system when the user enters hours, they have the option to either enter total hours, or spread the hours over the week. In line 1 above, the 16 Reg Hours and 2 Ovt Hours have been entered in the appropriate days. In line 2 above the 10.50 Reg Hours have not been spread out.
Other notes about the report: The employee can have any combination of Reg, Ovt, & Dbl time. If all three types of times are included, they'll have a line for each. If they only have 1 type, they will only have that type listed.
The model I described above works fine. I'd like to create a model that will show those hours that HAVE NOT been spread out (ie, missing the SAT - FRI fields). Any ideas?
This is using ver 7.