Add Reports Together?

G

Glenda

A roll of material is used to make final product. There can be more than one
roll of material used in the final product. The product has a serial number
(identifier) as does the roll of material. I want to track 'where was the
roll of material used?' by the final products' serial number.

For the life of me, I can't figure out how to make a report. The roll may
be used as the main roll in one final product and as the secondary roll in
the next final product. For this report, I don't need to know if it is the
main or secondary. So I want the first and secondary rolls to be added
together so that each final product is identified for the roll.

I hope this makes sense. Thanks in advance for your help.
 
L

Larry Daugherty

Hi Glenda,

If placement of the identifier and serial number for the roll is the
same in all of the records that track usage of a roll then the query
for your report would be pretty simple. However, if the records for
each case differ or are in different tables, your life could get
complicated because you haven't really managed your schema correctly.

With well designed tables, your Report's query should be as simple as
saying "for the roll of type(identifier) whose serial number is
"......" list all of the final product serial numbers where it
appears."

One thing you didn't mention is whether you show all activity for all
rolls as of a given time or only those that have been totally
consumed. If the latter, how is total consumption of a roll
indicated?


HTH
 
Top