I do I create a summary report of data using Access?

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

Guest

I imported a very large Excel spreadsheet into Access which breaks out the
hours paid to an individual during this year. I would like to create a
summary report of the total hours for each individual. How do I do this?

I was able to create a detailed report with a sub-total, but I would like to
see just the sub totaled amount and not all the details.
 
Set the Visable propety of the detail section to "no", just make sure that
your sub totals are in a group footer first
 
I imported a very large Excel spreadsheet into Access which breaks out the
hours paid to an individual during this year. I would like to create a
summary report of the total hours for each individual. How do I do this?

I was able to create a detailed report with a sub-total, but I would like to
see just the sub totaled amount and not all the details.
Click to expand...

Jen's suggestion is one good way; another is to create a Totals Query.
Create a new Query based on your table, and click the Greek Sigma icon
(looks like a sideways M). Change the default Group By to Sum on the
hours field (probably still leave Group By on the person's name). You
can then base your report on this Query.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
This can be done in Excel without exporting into Access.
Select the rows containing the data, including the header row.
Click "Data", "Subtotals"
In the "At each change in:", select the column to want subtotal for.
In the "Use function:", select "Sum"
In the "Add subtotal to:", select the columns you want the subtotals in.

Click "OK"
The resulting table will have "1, 2, 3" in the upper left corner.
Click on the "2" will show just the subtotals.
 
I understand this process, but when I go perform a VLookup into a new
spreadsheet and want to import just the summary information it won't work
since the column I used (Empl ID) to break on is not listed as "###### Total"
rather than just "######". Any other idea of how to keep the work Total out
this feature?
 
Back
Top