Record shows twice in a query

[fmaca]

Good morning.

I have a table with four columns, ID, PartNunmber, Quantity and Location.

When I run a query on "Location", one of the records shows up twice. If I total the PartNumber column, that part number shows 2 instead of 1.

Where should I look?

Thanks in advance.

Ethan

 

[humbleprogrammer]

Try a group query and make sure the part number is the 1st item in the group like below:

SELECT Table1.PartNumber, Table1.Quantity, Table1.Location
FROM Table1
GROUP BY Table1.PartNumber, Table1.Quantity, Table1.Location
HAVING (((Table1.Location)="Building1&quot);

Hope this helps..