Jump to content

Find and Return a unique count


N_is_4_Ninja
 Share

This topic is 4361 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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....

Link to comment
Share on other sites

  • Newbies

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

Link to comment
Share on other sites

This topic is 4361 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.