I also posted this in the forms section but it probably belongs here.
I am trying to create a DSum formula (to use as a control source in a chart) in a query that will look at a particular set of records(based on a product type), and take the value of that record's waste number (a calculated number) and divide that by the value of that record's LF Run number (entered by user).
The table name is: tblProductionNumbers
Waste is a calculated field already in the query. Waste: [LF Run]-[LF Produced]
LF Run is a value entered by user
LF Produced is a value entered by the user
So to do that "longhand" I would look at the query, which could contain dozens of records, and find all the records that are for the same product. Let's say that product is called "LL100". I would then sum up the waste numbers for the LL100 product, and then take that total and divide it by the sum of the LL100 product's LF Run numbers to arrive at a figure called "Waste%".
How would I construct this in a DSum formula?
I am trying to create a DSum formula (to use as a control source in a chart) in a query that will look at a particular set of records(based on a product type), and take the value of that record's waste number (a calculated number) and divide that by the value of that record's LF Run number (entered by user).
The table name is: tblProductionNumbers
Waste is a calculated field already in the query. Waste: [LF Run]-[LF Produced]
LF Run is a value entered by user
LF Produced is a value entered by the user
So to do that "longhand" I would look at the query, which could contain dozens of records, and find all the records that are for the same product. Let's say that product is called "LL100". I would then sum up the waste numbers for the LL100 product, and then take that total and divide it by the sum of the LL100 product's LF Run numbers to arrive at a figure called "Waste%".
How would I construct this in a DSum formula?
