Totals from different tables

[pl456]

I am trying to produce a report that totals and averages but I am having some problems figuring out how to show one of the totals.

For example, orders of fruit, I can get all of the many sided data such as Boxes, Weights etc (the individual order details) but can not get the total orders as this data comes from the one sided table.

The report would look something like this

Orders total Orders Boxes Weight Avg Weight
Apples
Oranges
Pears


Probably not explained this very well.

 

[SOS]

Yes, it would appear your explanation needs a little help.

Can you try again? But first I will mention that you might be looking for a main report for some of it and then a sub report to display the many side of the one-to-many relationships.

 

[pl456]

sorry, I was being stupid on this, it needed two queries to group the data from the seperate tables and then a third query to bring those two queries together.

 

[Psychadelic]

sorry wrong thread