Newbies N_is_4_Ninja Posted February 28, 2011 Newbies 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....
comment Posted February 28, 2011 Posted February 28, 2011 See if this helps: http://fmforums.com/forum/index.php?showtopic=61158&view=findpost&p=289204
Newbies N_is_4_Ninja Posted March 1, 2011 Author Newbies 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
Recommended Posts
This topic is 5018 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