Report Counter

J

J

I have a report that I need to be able to add up the numbers in a field
of my report and display a total on the report. For example:

I could have item 1 entered 5 times in my table with small differences
in the data, each quantity is 1 but is entered 5 times. I also have
other items that have different quantites as well. I need my report to
add up all the quantities for a specific number, output it, and then do
the same thing until all numbers have been counted. The report should
look something like this:


Item Number Total Quantity
1 5
2 3
3 25

So that no Item number is shown more than once. I hope this isn't too
confusing to understand.
 
D

Duane Hookom

If you want to display your detail information with summary information in
the report footer, create a totals query that Groups By Item Number and Sums
Quantity. Use this totals query as the record source for a subreport. Add
the subreport to the main report's Report Footer section.
 
J

J

I want to display this information in the actual Detail section of the
report so that an item number only shows up once but it displays the
total of all the quantities that are associated with that number.
Also, if I were to do that query, how would I get it to have multiple
totals for the separate Item numbers?
 
J

J

I don't have much experience with Totals queries, could you provide a
brief explanation of how they work?
 
K

KARL DEWEY

In the database window click on Queries. Click on menu New – Design View.
Select your table and close table drop down window.
Pull down you Item Number field twice.
On the menu click on the icon that is the Greek letter Epsilon. The design
grid change to the following row labels –
Field:
Table:
Total:
Sort:
Show:
Criteria:
Or:
In the grid for the second column and Total row select Count.
 
Top