Search results

Correction: The select I have is not working SELECT Temp.[Str #], Temp.M, Temp.[Street Address], Temp.City, Temp.State, Temp.[Zip Code], Temp.[Phone Nbr], Temp.Description, Temp.[Item #], Temp.YTD, Temp.OH, Sum(Temp.Qty) As SumQty FROM Temp GROUP BY Temp.[Str #], Temp.[Item #], Temp.Description...

Thanks for the advice. I have the select now that does this and it appears to be working. Would I just do this? INSERT INTO Table1 (Value1,value2,value3) Values (the select you recommended) is that the correct approach?

I have spent countless hours researching this issue and have found nothing that works. I have data in one table that has duplicate records... they aren't duplicate in the usual sense though, I need to sum the quantity field in those duplicates and make it one record. For example, PK Fields -...