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

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 11/12/04 

Date: Fri, 12 Nov 2004 00:09:54 -0700

On Thu, 11 Nov 2004 15:52:02 -0800, "Joanny5"
<Joanny5@discussions.microsoft.com> wrote:

>I imported a very large Excel spread*** 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.

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

Quantcast