Jump to content
Sign in to follow this  
dustinlp

Totaling a field w/out repetitions.

Recommended Posts

I work at a non-profit which keeps track of volunteers/vol. hrs.

I'm creating a layout which shows the total Volunteers during a given time period and the total hours they worked.

I am able to get the total number of everyones hours combined. I use a summary, no problems.

I don't get a correct number of actual volunteers, as some volunteers are counted multiple times.

Any ideas? Thanks!

Share this post


Link to post
Share on other sites

Look at this: http://www.fmforums.com/forum/showtopic.php?tid/135476/

Share this post


Link to post
Share on other sites

Well, I was able to get that far already...

Using the "Countries" example that was included, I am able to get the total number of "countries" (in my case "volunteer names") but when i do--a monthly report for example--i need the total number of unique volunteers (unique being the key, as I still seem to only get the grand total, which includes some people counted multiple times).

Thanks for the help...I feel like I'm just about there!

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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