Jump to content

find or calculate greatest number of recurrences


lanceomni

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

Recommended Posts

I have a database of sales records. I want to be able to sort or calculate the people/business who are most active:

example

Name: Price:

bob $3567

jim $567

bob $4798

bob $467

tim $3568

joe $567

tim $46

And I want the data to show something like this

# of records: Name:

3 bob

2 tim

1 jim

1 joe

Thanks, Justim

Link to comment
Share on other sites

There are about 47 ways to do that, Justim, depending on how your "database of sales records" is structured. And you haven't told us a single thing about that.

I suggest you post a brief description of where and how the different elements (names, amounts, sales etc) are stored and how they relate. Then there might be a chance of someone here offering advice that is more than a wild guess. :wink2:

Link to comment
Share on other sites

This topic is 6117 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
×
×
  • Create New...

Important Information

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