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