I am not sure if this is a table or a query question.
Basically, I have an access database that we use for work that we enter in our production daily. We enter the number of units and enter the materials used per unit as well as other data. One of the materials we use are obviously boxes for shipping purposes. Sometimes we use multiple boxes (ie, we may use 6 smaller boxes that get packed into a master case). But sometimes we use just a master case.
As of now, we categorize the boxes in the entry form as Inner Box and Outer Box. More often than not, all we use is an "inner box". We enter in the number of units that go into this box. If the product needs an extra box, we state the number of inner boxes go into the outer box.
So the issue is, at the end of the month, we run usage reports on materials. Currently, we run 2 separate reports for box usage. One being Inner box usage and the other being outer box usage. This is just an added burden to inventory and would prefer to use just a BOX usage report that combines the data from both of these fields and determines how much we used of each box within a given time period.
Just to show you an example for 4 different entries (NA is and will be excluded from report):
Inner box usage:
B Box - 200
A box - 350
Master Case - 50
E box - 300
Outer Box usage:
Master Case - 24
NA
NA
NA
I would like it combined so it would say:
BOX usage:
B Box - 200
A box - 350
Master Case - 74
E box - 300
Make Sense?
Thanks for the help!
Basically, I have an access database that we use for work that we enter in our production daily. We enter the number of units and enter the materials used per unit as well as other data. One of the materials we use are obviously boxes for shipping purposes. Sometimes we use multiple boxes (ie, we may use 6 smaller boxes that get packed into a master case). But sometimes we use just a master case.
As of now, we categorize the boxes in the entry form as Inner Box and Outer Box. More often than not, all we use is an "inner box". We enter in the number of units that go into this box. If the product needs an extra box, we state the number of inner boxes go into the outer box.
So the issue is, at the end of the month, we run usage reports on materials. Currently, we run 2 separate reports for box usage. One being Inner box usage and the other being outer box usage. This is just an added burden to inventory and would prefer to use just a BOX usage report that combines the data from both of these fields and determines how much we used of each box within a given time period.
Just to show you an example for 4 different entries (NA is and will be excluded from report):
Inner box usage:
B Box - 200
A box - 350
Master Case - 50
E box - 300
Outer Box usage:
Master Case - 24
NA
NA
NA
I would like it combined so it would say:
BOX usage:
B Box - 200
A box - 350
Master Case - 74
E box - 300
Make Sense?
Thanks for the help!
