Addup and Replacement values query

[desp]

Hi,

I basically need a query where I have to add up numbers for groups of records, write the subtotals on the "leaders" of those groups, but write as well the original value for the non-leaders.

Example:

A and B are in "group1". C and D are in "group2". The table looks likes this:


Element Number
___________________
A 3


B 2
C 1
D 5

Suppose A is leader of group1 and D is leader of group2.

This is what I want:

Element (AggregatedNumber)
_____________________________
A 5
B 2
C 1
D 6

So far I have created a query to obtain this:

Element Aggnumber
A 5
D 6


So I'm trying to bring it back into the original table by creating relationships, but so far it hasn't worked. There are probably many other ways of solving this. Any ideas?

your help is much appreciated!

David

[orange]

Based on the info you have provided, what tells us anything about Groups? Or Leader of a Group? I don't think you've given us all the info, or, you have a tables/structure issue.

You may wish to read the Database materials at this site:
http://forums.aspfree.com/attachment...achmentid=4712