Duplicates

[tagah]

Hi does anybody know how to get combine duplicate lines and quantities.

Client Code -- Order # -- Client Name -- Qty -- Style #
SI001 200100 Mike Civ 1 MLX-1568
SI001 200100 Mike Civ 1 MLX-1568
SI001 200450 Chris Style 1 MLx-1590
SI001 215435 Alex Mike 1 MLX-1700
SI001 215439 Josh Head 1 MLX-1220
SI001 215439 Josh Head 1 MLX-1220

I would like to remove the duplicate line. Then I like to add the duplicate records together and combine the quantities. Then combine the query with the original table. Can anybody help me.

 

[vbaInet]

Go to the SQL VIEW of your query and put the keyword DISTINCTROW after the word SELECT. So this:

SELECT DISTINCROW ...

 

[tagah]

It doesn't work. It does not combine duplicate records. I need to select all columns as well.

 

[vbaInet]

Alright, I thought you said you wanted to supress the duplicate records. What you are looking to do is SUM the quantities per order number right?

You GROUP BY Client Code, GROUP BY ORDER#, SUM() quantity. Play around with that in your query view.