Jump to content

Count of specific data selected in a field


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

Recommended Posts

  • Newbies

I have a relational database called Graduate Applicant Status. In it I have a pull down field listing available graduate programs, which pulls the appropriate program code from another database. My question is, without doing a find for each program (there are approx. 55) and counting manually, is there a way do to a count based on what info is selected from the pull down menu?

Any help would be appreciated. smirk.gif

Link to comment
Share on other sites

1) Define a global, g.PullDownValue to match the field with the program code (I'll call it ProgramCode).

2) Define a relationship between g.PullDownValue and ProgramCode, I'll call it CountRel:

g.PullDownValue::ProgramCode

3) Make a calculation field c.ProgramCode.Count with Count(CountRel::ProgramCode)

4) Set g.PullDownValue & the calc field will show the count!

You can design this so that the counts for all individual programs are always available. Let us know if you want to try that (it's more complex...).

Link to comment
Share on other sites

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

×
×
  • Create New...

Important Information

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