Concatenate query records

[Takunda Mafuta]

I want to create a query (Resultant Query) which concatenates records from another query (Source Query). For example:

Source Query
A 10
B 15
A 6
C 4
C 5

Resultant Query
A 16
B 15
C 9

 

[Gasman]

That is not concatenating, that is summing.

Just use a Totals query on the source query, grouping by field 1 and summing field 2.

HTH