Total the number of discreet values?

[jms181]

What would the calculation be to get the number of discreet values in a field over several records?

I'm building a database to keep track of shots in a movie. Each shot has a SceneNumber field that assigns the shot to one of the movie's scenes. If I create a found set of all shots added to the database in a given week, and I want to know how many different scenes are represented in that found set, what would the calculation be? That is, how do I total the number of discreet values in the SceneNumber field across all the records?

Thanks!

[dreamingmind]

How 'bout setting up a relationship so the records in question can be collected

Then build a value list to pull field of interest together (this will omit duplicates)

Then get the count of value list items (ValueCount (listhere))

Don

[jms181]

Then build a value list to pull field of interest together (this will omit duplicates)

Could you explain this step. I don't understand.

Thanks!

[jms181]

Nevermind! Just figured it out.

Thanks so much! I really appreciate it.

Jon

[dreamingmind]

In the menu File:Manage:Value Lists...

you can build value lists for pop up lists, radio buttons, checkboxes and the like.

You can build lists from data you type or from related data. Yours will be from related data.

Don