109k records lots of dup names

[Mhypertext]

u have

6 colums player ID first name last name the other fiedls are numbers that i want to comebine

is there a query that will add everything to one row for that player ID

 

[Rabbie]

Without knowing your data structure I would suggest you look at aggregate queries grouping on Player Id. You may need to do this with two queries using the first one to calculate the sum for each row and the second to get the total for each player if you have more than 1 row for each player.

 

[Mhypertext]

yes i want to keep the first 3 colums the same and sum the last 3 colums

where do i start can i run this against the query i already have