Newbies N_is_4_Ninja Posted February 28, 2011 Newbies Share Posted February 28, 2011 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 More sharing options...
comment Posted February 28, 2011 Share Posted February 28, 2011 See if this helps: http://fmforums.com/forum/index.php?showtopic=61158&view=findpost&p=289204 Link to comment Share on other sites More sharing options...
Newbies N_is_4_Ninja Posted March 1, 2011 Author Newbies Share Posted March 1, 2011 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 More sharing options...
Recommended Posts
This topic is 4795 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 accountSign in
Already have an account? Sign in here.
Sign In Now