Combine & total like records in a group

  • Thread starter Thread starter Mark McCauley
  • Start date Start date
M

Mark McCauley

I have a report that consists of groups of parts that have four fields -
qty, width, length, and description.

Each record is individually listed. For example:

Qty Width Length Description
1 12 24 Top
3 12 24 Top
5 12 24 Top
___
9

I would like to able to combine and total the records on the report when the
width and the length and the description are each equal. For the previous
example:

Qty Width Length Description
9 12 24 Top
___

How can I do that?
 
Mark,

Assuming your record source is a query (make it one if it
isn't) create a calculated field the query such as:
Joined:[width]&[length]&[description]. Use the new
field "joined" to group on in your report with a group
footer where a sum([qty]) control will give the results
you desire. This may not be the best way to do this .....
but if it works ...?

HTH,

Terry
 
Terry,

My report source is a query. I added the new "joined" field as you suggested
and edited it for spacing. It seems like that is going to work.

Thanks!

Terry said:
Mark,

Assuming your record source is a query (make it one if it
isn't) create a calculated field the query such as:
Joined:[width]&[length]&[description]. Use the new
field "joined" to group on in your report with a group
footer where a sum([qty]) control will give the results
you desire. This may not be the best way to do this .....
but if it works ...?

HTH,

Terry
-----Original Message-----
I have a report that consists of groups of parts that have four fields -
qty, width, length, and description.

Each record is individually listed. For example:

Qty Width Length Description
1 12 24 Top
3 12 24 Top
5 12 24 Top
___
9

I would like to able to combine and total the records on the report when the
width and the length and the description are each equal. For the previous
example:

Qty Width Length Description
9 12 24 Top
___

How can I do that?




.
Click to expand...
Click to expand...
 
Back
Top