A aoswald Registered User. Local time Today, 03:46 Joined Sep 20, 2005 Messages 45 Jan 9, 2009 #1 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
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 Allan Local time Today, 08:46 Joined Nov 29, 2004 Messages 336 Jan 9, 2009 #2 Use the Totals function within the query. Group on associates, sum on Training credits with a criteria >=16
Use the Totals function within the query. Group on associates, sum on Training credits with a criteria >=16
A aoswald Registered User. Local time Today, 03:46 Joined Sep 20, 2005 Messages 45 Jan 9, 2009 #3 I understand the =>16 but I don't know how to group on associates
allan57 Allan Local time Today, 08:46 Joined Nov 29, 2004 Messages 336 Jan 9, 2009 #4 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
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
A aoswald Registered User. Local time Today, 03:46 Joined Sep 20, 2005 Messages 45 Jan 9, 2009 #5 Got it - works great - thanks
