Question Adding Multiple Records

[Oucch]

Basically I have 12 different ingredients but many orders. More than one order is shown at a time. I need a formulae to take all the ING01 values, add them together then subtract them from the current level in the Vat. This needs to be done for all 12 ingredients; ING02, ING03 etc..

Anybody know how this can be done? Thanks.

 

[Oucch]

Ok I have a scenario of a perfume business.
There are 11 Perfumes.
Each contain 12 differnet ingredients (ING01, ING01, ING03 etc..)

I have made a form which shows the Order ID and status of the order, along with a subform with information of the order ingredients.

I need to do a formulae or something where I can add each ingredient together then take it away from a VAT Level. The trouble is, as I have more than one order in the subform, I need it to add up the corresponding ingredients, so ING01 (of order 1) + ING01 (of order 2) then take this figure away from the VAT Level so it is updated.

Is that clearer?

I been thinking about it, maybe I could just group the ING so there were only 1-12 and all the batches added together? How could I do this?

 

[Oucch]

The VAT does have a seperate field, a different figure for each ingredient.

 

[Oucch]

I want to take the total ingredients used away from the vat.

 

[Mike375]

I am reading this as he wants to add only selected records in the subform and that result is to be used as the basis of calculation.

 

[Oucch]

I am reading this as he wants to add only selected records in the subform and that result is to be used as the basis of calculation.

yes basically

 

[Oucch]

what do you mean, im kinda new to access?

 

[Mike375]

what do you mean, im kinda new to access?

If you don't understand Tony's question then this will be a long haul

I would suggest you post your DB as an attachment or at least extracts that are relevant to the problem.


In a nutshell, if Access is to add the values from selected records from the subform display then it needs something to use. In other words do the selected records have some entry that is common to them.

For example in an earlier post you said....I need it to add up the corresponding ingredients, so ING01 (of order 1) + ING01 (of order 2) then take this figure away from the VAT Level so it is updated.

So do those two records have something in common whereby Access could select them. Or is it a case that you want the calculations done on Order 1 and Order 2.

 

[Oucch]

Ok I have uploaded what I have made so far. Just to clarify its the Sum_of_Batches form. Hopefully when you see it, it will make more sense.

I want ingredients 1-12 so they dont repeat for each order.

 

[Mike375]

The two records have subforms dispays of 2 sets of 1 to 12 for ingredients.

Is it the order number you are try to select.

 

[Oucch]

Instead of the 2 sets (2 orders) I want the batches for each ingredient to add together.

 

[Oucch]

yeah, i need to be able to view how much total ingredient is required, then I can just update the vat level by taking it away and updating the status of the order.