Have detail records, want to group on one field get totals of oth.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS ACCESS INVENTORY CALCULATION 0
Access Inventory Calculation 0
Query for Obtaining Detail Records 6
Summing multiple input records into one output rcd query 2
Current Total Data 8
Number to Number "Data Type Mismatch in Expression" in Join 1
Add a field to Query 2
Displaying summary level results from a query 8

Back
Top