Grouping question

[FRED_EMMERICH_(Guest)]

I have v12 running against a .mdb database. I have a one-to-one join between 2 tables. In my master table I have "pairs" of records that represent the same entity, and the joined table brings in a number. So for example, I have record A and record B from my master bringing in 100 and 200 respectively. What I want to do is to sum the numbers by "pair", and then sort that total. How would i go about doing that? I made my summary for the pairs pre-processed but that did not keep them together and it did not work.____thanks__fred

[kfleming]

So you want to total the A, B, C detail from the joined table and then sort by sum of the detail so if A summed to 10, B to 20 and C to 5 the report would show in B A C sequence?____Kathleen__R&R Support