B
brian
Hi, I am working on a database to track downtime on my production
line. I have setup a form so you can use a drop down menu to select
the downtime reason, and next to that reason you can insert the number
of minutes we were down.
What I want to do is be able to calculate total downtime for each of
my reasons (from the pulldown list) and be able to use this data to
calculate which reason caused the most downtime. Below I have listed
an example of fields from my table.
1:Reason for Downtime 1
pull down list)
2:Reason for Downtime 2
pull down list)
3
owntime 1
number)
4
owntime 2
number)
If field 1 says: 'Machine Stops' then field 3 would have '15'
Then if field 2 says: 'Lunch' then field 4 would says '30'
I would like to sort the reasons and add up the minutes.
The problem is I don't know what to use to do this. It sounds like I
am going to have to write some code so that i can search for my
different reasons then grab the number of minutes from a different
cell and add them up.
Any ideas? Should I use a querie? Macro? VB Code? Pivot Table? Any
help would be apreciated.
Thanks
Brian
line. I have setup a form so you can use a drop down menu to select
the downtime reason, and next to that reason you can insert the number
of minutes we were down.
What I want to do is be able to calculate total downtime for each of
my reasons (from the pulldown list) and be able to use this data to
calculate which reason caused the most downtime. Below I have listed
an example of fields from my table.
1:Reason for Downtime 1
![Frown :( :(](/styles/default/custom/smilies/frown.gif)
2:Reason for Downtime 2
![Frown :( :(](/styles/default/custom/smilies/frown.gif)
3
![Big Grin :D :D](/styles/default/custom/smilies/grin.gif)
![Frown :( :(](/styles/default/custom/smilies/frown.gif)
4
![Big Grin :D :D](/styles/default/custom/smilies/grin.gif)
![Frown :( :(](/styles/default/custom/smilies/frown.gif)
If field 1 says: 'Machine Stops' then field 3 would have '15'
Then if field 2 says: 'Lunch' then field 4 would says '30'
I would like to sort the reasons and add up the minutes.
The problem is I don't know what to use to do this. It sounds like I
am going to have to write some code so that i can search for my
different reasons then grab the number of minutes from a different
cell and add them up.
Any ideas? Should I use a querie? Macro? VB Code? Pivot Table? Any
help would be apreciated.
Thanks
Brian