J
JG
hello,
i have a table and i want to aggregate rows that have a certain field in
common. for instance:
Name Description Owes
TOD A nice fellow 25.00
SALLY Smart lady 1.00
TOD A good guy 10.00
FRANK A lawyer 5.00
i want to eliminate the duplicates by adding the 'Owes' column so that i
would get:
Name Description Owes
TOD A nice fellow 35.00
SALLY Smart lady 1.00
FRANK A lawyer 5.00
now tod only has one record, and his total is bumped up to 35.00.
note that the first 'Description' is used ..
how the heck can i do this? i have to take the first occurrence of the
record that has duplicates, keep all the miscellaneous columns, but add up
just the one or two columns i'm interested in...
i am open to doing this through query building or code, but don't have any
idea how. can someone point me in the right direction? i can't get it to work
with queries.
thanks,
jg
i have a table and i want to aggregate rows that have a certain field in
common. for instance:
Name Description Owes
TOD A nice fellow 25.00
SALLY Smart lady 1.00
TOD A good guy 10.00
FRANK A lawyer 5.00
i want to eliminate the duplicates by adding the 'Owes' column so that i
would get:
Name Description Owes
TOD A nice fellow 35.00
SALLY Smart lady 1.00
FRANK A lawyer 5.00
now tod only has one record, and his total is bumped up to 35.00.
note that the first 'Description' is used ..
how the heck can i do this? i have to take the first occurrence of the
record that has duplicates, keep all the miscellaneous columns, but add up
just the one or two columns i'm interested in...
i am open to doing this through query building or code, but don't have any
idea how. can someone point me in the right direction? i can't get it to work
with queries.
thanks,
jg