Concatenate query records (1 Viewer)

T

Takunda Mafuta

Registered User.
Local time
Today, 05:58
Joined
Sep 4, 2019
Messages
13
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

Gasman

Enthusiastic Amateur
Local time
Today, 13:58
Joined
Sep 21, 2011
Messages
14,235
That is not concatenating, that is summing. :confused:

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

HTH
 
You must log in or register to reply here.

Similar threads

raziel3
Solved Help to Convert Single Range to Min and Max (RE: http://allenbrowne.com/ser-58.html)
Replies
3
Views
467
CJ_London
C
M
Solved Top values for unique records
Replies
5
Views
348
bob fitz
bob fitz
J
Solved Age Deomgraphics
2
Replies
27
Views
642
GaP42
G
B
Solved Query Error
2
Replies
20
Views
1,225
broberts
B
A
Query for Pass/Fail/Totals
Replies
5
Views
158
ashleymac
A

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom