Jump to content

Tallying Value Lists in a Field


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

Recommended Posts

  • Newbies

First time posting and I hope this isn't too basic a question. I'm probably more novice than intermediate when it comes to FileMaker.

I work in human rights non-profit. I have a field in database marked "Race". Within this field we have a value list for White, Hispanic, African American, etc.

For reports, I need to show how many people of each race are contacting my office within a found group. I know I could set up the races individually as text boxes and then set up another field to tally, but I like having the value lists (race types) all within one field vs. separate fields.

If anyone could help point me in the right direction for the script, I'd really appreciate it. I've tried some different calculation/summary combinations and am not finding the winning one yet.

Link to comment
Share on other sites

The "race" field should only have one entry.

Create a summary report to display the data you want: use the wizard if you're not sure how to do it, it's not too bad.

Link to comment
Share on other sites

This topic is 5765 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

  • Who Viewed the Topic

    2 members have viewed this topic:
    hurstja  abross86 
×
×
  • Create New...

Important Information

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