View Full Version : Help with sum formula in query


aoswald
01-09-2009, 05:00 AM
I have a table the tracks training hours for associates. Training credits are earned in 1,2,and 3 hour blocks I want to know the names of associates that have completed at least 16 hours. How do I do that?

thanks

allan57
01-09-2009, 05:14 AM
Use the Totals function within the query. Group on associates, sum on Training credits with a criteria >=16

aoswald
01-09-2009, 05:16 AM
I understand the =>16 but I don't know how to group on associates

allan57
01-09-2009, 05:26 AM
Hit the Total button in query build mode, this will then give the the option to group, sum etc.

See image for where the Total button is

25061

aoswald
01-09-2009, 05:27 AM
Got it - works great - thanks