Totals from Value Lists...

[artfairs]

Please help me out, I'm stuck! :

I have a value list (it's a drop down), that lists different booth sizes (ie: Small, Medium, Large, X-Large) that people request when they apply to be in our trade show.

I want to get a grand total of these size requests.

I was thinking, I want to create another field that will tell me how many small booths someone has requested, how many medium, etc. etc.

Can someone tell me how to do this?

All help is very much appreciated.

[Fitch]

Simplest way to do it is to create a report and summarize by size.

[artfairs]

I want to create an interface so my boss can look at the figures. He isnt very skilled at Filemaker but still needs to have easy access to the information. I need a calculation to separate the value list (small, medium, large, x-large booths) and then does a count of each type. Any help?

[sbg2]

Exactly as Fitch said a report can do this. See if attached example helps.

Report.zip