Repeated Items In Report

[ping]

Hi,

I created warehouse table with fields like: Catalog No., Producer, Serial number, Qty., Description, incoming date and outcoming date. I also have a calculation field which tells me if item is on stock or it has been delivered. To know what I have on stock I created new list view layout and script which basically create report with items I have on stock and summarize how many items I have for each category. Records are organize by Catalog number. Problem appears when I create report, some items are repeated. However, item count is correct.

For example: if I have following records:

Cat No. Description Qty

123 A 1

234 B 5

345 C 2

123 A 3

234 B 1

345 C 1

My report looks like:

123 A 4 - correct

234 B 5

234 B 1

345 C 3 - correct

Catalog number field is text field whith option Auto complete using existing values. I was not able to find pattern, why this happens on certain items.

Tomislav

[comment]

Most likely, one of the "234" records has a trailing space or something similar.

[ping]

You are right. I thought it might be something with file name, and I tried to copy name only. Now I tried to copy entire field and this solved the problem. Thank you for this tip.