(Solved) Duplicated Records On Query...

[G-Hawk]

Hi everybody... I have loooking for some answers to my problem in the forum but I got nothing... so here I am....

Lets say that Table A has the following fields: Order,Rack, ID, INDate, EndDate.
And TableB has: Order, Model, Line, CaptDate, Qty.

Here is my query for a lis of racks used by Line:

SQL = "SELECT Rack, Sum(1) as TotalRack FROM TableA " _
   & ", TableB WHERE TableA .Orden = TableB.Orden" _
   & " AND TableB.Linea = '" Line "' GROUP BY Rack ORDER BY TotalRack DESC"

I found that I got repeated records if Orden is repeated in TableB, so the question is how can I get rid of those duplicated records?... I mean that if there is a match and TableA.Orden exist in TableB then it counts (thats OK) but if TableA.Orden exist twice then it counts twice (thats not good)...

Hope you can help me...