So I have an access data base with a bunch of columns. I added an additional column at the end for a unique value.
Most of the values in that column are unique, although I have some multiples for when the rows which represent orders came in at the same time.
Here is what I want to do. I want to sum the weights and pieces received based on the values in the unique record column. I have a bunch of extra crap like addresses etc that I want in the results as well so the number of columns is too big for a pivot table in excel.
How do I sum values in other columns based on the unique identifier column? This would result in two orders with the identifier XYZ turning into one entry with the identifier XYZ while having their weights and pieces added by the query.
Thanks!
Most of the values in that column are unique, although I have some multiples for when the rows which represent orders came in at the same time.
Here is what I want to do. I want to sum the weights and pieces received based on the values in the unique record column. I have a bunch of extra crap like addresses etc that I want in the results as well so the number of columns is too big for a pivot table in excel.
How do I sum values in other columns based on the unique identifier column? This would result in two orders with the identifier XYZ turning into one entry with the identifier XYZ while having their weights and pieces added by the query.
Thanks!
