Printing selected information from Queries

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

If I have a Query that looks like this

Type Size Amount
a .75 1000
a .75 2000
bbb .25 2250
bbb .25 1000
bbb .25 3653
a .75 8956
a .75 10000
a .75 5484
bbb .25 6549

How would i have a report prints out the total amounts for
type "a" on one line followed by the totals of type "bbb"
on the next line. I know how to do this on different
reports but i cant figure out how to do this on the same
report.

Thanks a lot, Stuart
 
Type Size Amount
a .75 1000
a .75 2000
bbb .25 2250
bbb .25 1000
bbb .25 3653
a .75 8956
a .75 10000
a .75 5484
bbb .25 6549


Sorry about the last post. This is a very basic example
of what Im doing but i think if you can explain this to me
I will be able to figure mine out.
When the report prints, this is what I want it to read
Type Size Quantity(SUM of each type)
"a" .75 27400
"bbb" .25 13452
I hope this is more clear, I can sort the TYPE field on
the query, but as far as I know, I can only sort a field
once on a report.
 
Thank you, but I figured it out on my own, Sorry for the
sloppy first post! Stuart Gilchrist
 
Back
Top