C
Cam
Hello,
I have an Access Database 2000 to track performance. Within the db I have a
performance table where user input their ID, date, part#, side, start
sequence &
stop sequence daily (there can be two entries per day). Then on another
reference table with field: part#, side, sequence#, time (min).
What I would like to calculate in the query and report is look at the start
& stop sequence based on the part# & side then calculate how long (time) the
operator spend on the job (part#). Thanks
Example:
Table1
ID date part# side start seq stop seq
001 1/8/08 1360-1 1st 100 500
002 1/10/08 1560-3 2nd 600 1000
Table2
part# side start seq time (min)
1360-1 1st 100 5
1360-1 1st 200 10
1360-1 1st 300 10
1360-1 1st 400 30
1360-1 1st 500 15
1360-1 1st 600 60
1560-3 2nd 100 10
...........
Result
query or report output:
ID date part# side start seq stop seq Total time (min)
001 1/8/08 1360-1 1st 100 500 70
Can you give help with query and report design? Thanks
I have an Access Database 2000 to track performance. Within the db I have a
performance table where user input their ID, date, part#, side, start
sequence &
stop sequence daily (there can be two entries per day). Then on another
reference table with field: part#, side, sequence#, time (min).
What I would like to calculate in the query and report is look at the start
& stop sequence based on the part# & side then calculate how long (time) the
operator spend on the job (part#). Thanks
Example:
Table1
ID date part# side start seq stop seq
001 1/8/08 1360-1 1st 100 500
002 1/10/08 1560-3 2nd 600 1000
Table2
part# side start seq time (min)
1360-1 1st 100 5
1360-1 1st 200 10
1360-1 1st 300 10
1360-1 1st 400 30
1360-1 1st 500 15
1360-1 1st 600 60
1560-3 2nd 100 10
...........
Result
query or report output:
ID date part# side start seq stop seq Total time (min)
001 1/8/08 1360-1 1st 100 500 70
Can you give help with query and report design? Thanks