Summing information from a Query for use in a report

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

Guest

I have information from a query that i need to sum in a report, this is what
the query returns

7A0001 2
7A0004 3
7A0301 4
7A0302 9
7A1001 4
7A1011 6

This is the information that i am getting using my query. My report pretty
much also displays this message. What I need to do is get the Report to Sum
everything that start with 7A00, 7A03, 7A10

I want my report to basically look like this

7A0001 2
7A0004 3
Sum 7A00 5

7A0301 4
7A0302 9
Sum 7A03 13

7A1001 4
7A1011 6
Sum 7A10 10

Can anyone help
 
I have information from a query that i need to sum in a report, this is what
the query returns

7A0001 2
7A0004 3
7A0301 4
7A0302 9
7A1001 4
7A1011 6

This is the information that i am getting using my query. My report pretty
much also displays this message. What I need to do is get the Report to Sum
everything that start with 7A00, 7A03, 7A10

I want my report to basically look like this

7A0001 2
7A0004 3
Sum 7A00 5

7A0301 4
7A0302 9
Sum 7A03 13

7A1001 4
7A1011 6
Sum 7A10 10
Click to expand...

Add a calculated field to your table:

SomeFieldName: Left([your7Afield], 4)

Use the Report's Sorting and Grouping feature to group by this
calculated field; display the section Footer, and use textboxes on
this footer to sum the values.

John W. Vinson[MVP]
 
Back
Top