Hi,

I am simply trying to find the count of Salesmen that have so many sales for the month. I just want the total count of Salesman, but to ignore the sales they have made. I have 10 Salesmen ( and Women ), who have made anywhere between 2 to 10 sales per month on specific items. When I do a find, I just want the total count of Salesmen and not the 5 to 10 sales they have made.

Salesmen ID= text field

Items = text field

Item price = number field

So for the month of January my layouts look like this:

Salesman 0100

Item 1 - $50

Item 2 - $30

---------------

SubTotal Sales = 2 items for $80

Salesman 0200

Item 1 - $40

Item 2 - $20

Item 3 - $75

I would like to just find how many Salesmen sold Items? It should be 2 here, but every Summary function I have tried shows total of 5....

Heelllpppp....

See if this helps:

http://fmforums.com/forum/index.php?showtopic=61158&view=findpost&p=289204

See if this helps:

http://fmforums.com/forum/index.php?showtopic=61158&view=findpost&p=289204

Outstanding. I could not have completed my report without your help. I really appreciate it. I still can't understand why FMPRO doesn't have some sort of Unique record search -- ( or maybe I am just not finding it. )

Cheers,

Jason