Jump to content

How many records contain exact data in the same field


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

Recommended Posts

Hi everyone! :P-)

I'm looking for a calculation field that yields a number. The number would tell how many records contain exact data in a certain field.

Example: There are 10 records in an "Address Book" database. There is only one table in this database. This is the contents of the "FirstName" field of each record:

The first name Bob occurs 3 times.

The first name John occurs 4 times.

The first name Sally occurs 2 times.

The first name Martha occurs 1 time.

When someone is flipping through the records and they come to a record with the first name of Bob - the calculation field would show the number 3.

When someone is flipping through the records and they come to a record with the first name of John - the calculation field would show the number 4.

When someone is flipping through the records and they come to a record with the first name of Sally - the calculation field would show the number 2.

When someone is flipping through the records and they come to a record with the first name of Martha - the calculation field would show the number 1.

Thanks, kcep

Link to comment
Share on other sites

Lee thanks for pointing me in the right direction! :P-)

I'm getting closer, but I'm still lost on my final step.

Could you take a quick look at the attached database and see how I'm doing. I still don't know how to get the final number.

Thanks! kcep

Address_Book.fp7.zip

Link to comment
Share on other sites

Hi Lee !

Getting closer ;-)

I need the calculated answer to work if the records are sorted or not sorted. Right now the calculation only works if it is sorted. The reason I need it like this is because this calculated answer will be used in another calculation later on.

Also, I've changed the way that I'm presenting my problem. (see new attached database) I'm not sure this will make a difference in the way this problem is addressed, but I'm actually working with numbers and not text in the "Name" field. - Just thought I should say that in case it matters.

Thanks a bunch! You're brilliant!

kcep

Address_Book-1.fp7.zip

Link to comment
Share on other sites

This topic is 6562 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.