Grouping similar fields

[ruth10uk]

I have two linked tables one with formulations on the other with stock quantities of the raw materials on. I have numerous queries incorporating the formulation of one product and mulitplying it by the batch size (which will change from week to week).

What I now need to do is put all the queries together so I can find out all the raw matierlas for one week and then group the same raw material together to get a total amount of each raw material used in the a week.

Please help !!!!!

Thanks

 

[neileg]

I suspect your design isn't ideal. However, if you want to link all these queries together, assuming they contain the same fields, you can use a union query.

It would be better to do all the calculations in one query in the first place, but you haven't give us much information to go on to help.