Hi
I have an access table with over 2000 record and want to combine the number in the field Weight, Amount and Cost under the same Product ID field. Please advise how to write the query to combine.
Asof Client No Client Name ProdID Product Name Weight Amount Cost 20191129 XYZ Dummy 0130Z3P46 Brown Sugar 23,835.78 23,733.29 23,733.29 20191129 XYZ Dummy 0130Z3P46 Brown Sugar 176,193.76 175,436.13 175,436.13 20191129 XYZ Dummy 1350Z74J0 Lime 11,441.18 11,413.71 11,413.71 20191129 XYZ Dummy 1350Z74J0 Lime 24,026.42 23,969.72 23,969.72 20191129 XYZ Dummy 235851102 Strawberry 144.58 28,033.45 25,919.67 20191129 XYZ Dummy 235851102 Strawberry 1,901.93 368,780.77 174,616.83 20191129 XYZ Dummy 2852533 Pineapple 254.52 71,223.79 70,940.46 20191129 XYZ Dummy 2852533 Pineapple 372.27 104,173.71 119,761.68 20191129 XYZ Dummy 2GFKW32 Orange 44,811.27 44,639.06 44,639.06 20191129 XYZ Dummy 2GFKW32 Orange 424,623.20 423,050.98 423,050.98 20191129 XYZ Dummy 5069211E Pear 122.43 12,318.14 9,688.79
Regards
Bill