G Guest Oct 29, 2004 #1 I have a table with detail payroll records. I want a query that will summarize the payroll detail based on job no (repeating value)
I have a table with detail payroll records. I want a query that will summarize the payroll detail based on job no (repeating value)
J John Vinson Oct 30, 2004 #2 I have a table with detail payroll records. I want a query that will summarize the payroll detail based on job no (repeating value) Click to expand... Create a Totals query by adding your table to the query grid; change it to a Totals query by clicking on the Greek Sigma icon (looks like a sideways M). Put "Group By" on the JobNo and Sum on the field that you want to sum. John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps
I have a table with detail payroll records. I want a query that will summarize the payroll detail based on job no (repeating value) Click to expand... Create a Totals query by adding your table to the query grid; change it to a Totals query by clicking on the Greek Sigma icon (looks like a sideways M). Put "Group By" on the JobNo and Sum on the field that you want to sum. John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps
