A
artist02
I am still a novice in Access, to simplify my problem, here is a sample table.
..
Date Shift Time Target
Error Downtime
14-06-06 x 6:30 160
E1 15
14-06-06 x 7:30 160
14-06-06 x 8:30 160
E15 60
Now the problem is that i want to create a report that shows for a specific
date and specific 8-hour shift all the errors which occured (inputted through
a form) and their downtimes and all the errors which did not occur( not
inputted ).The downtimes of errors which did not occur should be equated to
zero Please note that there are 36 possible errors which can occur at any
particular time (E1-E36). If an error occurs more than once only the total
downtimes are shown.
An example of what I want to achieve:
Date: 14-06-06 Shift: X
E1 20
E2 0
E3 0
E4 5
.. .
.. .
..
Date Shift Time Target
Error Downtime
14-06-06 x 6:30 160
E1 15
14-06-06 x 7:30 160
14-06-06 x 8:30 160
E15 60
Now the problem is that i want to create a report that shows for a specific
date and specific 8-hour shift all the errors which occured (inputted through
a form) and their downtimes and all the errors which did not occur( not
inputted ).The downtimes of errors which did not occur should be equated to
zero Please note that there are 36 possible errors which can occur at any
particular time (E1-E36). If an error occurs more than once only the total
downtimes are shown.
An example of what I want to achieve:
Date: 14-06-06 Shift: X
E1 20
E2 0
E3 0
E4 5
.. .
.. .