How do I query multiple fields, and sum them all up?

[chuffy]

I have a table with transactions. The transactions are for both Parent companies and Child Companies.

I created another table with the Parent in one field, and all the child companies as other fields of the Parent record.

Can I use a query to sum all of the transactions for all of the child companies and the parent company, and combine them.



My goal: To sum all transactions from both parent and child companies within a data range.

I can do them all seperately, because I have all the company records(child and parent) as seperate records, in a Customer table, however I am having difficulty determining the best method for combining the parent and child company totals together.

[dsmacs]

Chuffy,

I would just have one table for customers with a field called something like Parent. You will also need to create Customer Account Numbers, use a autonumber field if necessary. If the company is Parent than the Parent ID would be 0, otherwise if the company is a child the Parent Company account number would be entered in Parent ID Field.

Once you have a link to both child and parent companies it will be easy to report on totals/subtotals.