I'm hoping this is easy and I'm just missing something simple.

Here's my issue - I found a survey db which I've been able to customize for a solution I'm trying to provide.

I created a db which allows teachers to vote (yes, no or nt) for students for an award. They can also add comments. The issue I have is totaling the votes for each individual student.

I created a totals layout which has a portal that pulls the teacher name, vote, and comments for an individual student. However, I haven't found a way to successfully total the number of yes, no or nt votes for that student.

I'd be happy to send a copy of the db if needed.

Thanks,

This would be better served with a report. If you need it in a portal, you can use a method we commonly call Ugo's method on here.

http://fmforums.com/forum/showpost.php?post/157908/