Total Product Quantity for Multiple Records

[shamrog12]

My situation explained:

I have 15 fields I need to use information from (3 rows of 5):

Product01, Product02, Product03, Product04, Product05

Quantity01, Quantity02 ... Quantity05

ID01, ID02, ... ID05

My fields are set up like this:

| Product01 | Quantity01 | ID 01 |

| Product02 | Quantity02 | ID 02 |

| Product03 | Quantity03 | ID 03 |

| Product04 | Quantity04 | ID 04 |

| Product05 | Quantity05 | ID 05 |

A possible scenerio would look like this:

| Baseball Glove | 20 | BG001 |

| Football | 5 | FB001

| Volleyball Net | 20 | VB001

With hundreds of records with these fields and information on them, I need to find out how I can display the total quantity of BG001 sold throughout all the records and the total quantity of FB001 sold throughout all the records and same for VB001.

I have NO CLUE how to do this and I've been trying to figure it out for days now with absolutely ZERO luck. Please help!

[danjacoby]

First, I'd do the rows thru portals to a related file. That way, you don't have 5 different "ID" fields you're trying to add together.

Then you can create a summary report in the related file with a summary field that totals the "ID" field. Put it in a sub-summary part, sorting by ID. Then sort by ID and go to Preview mode, and you'll see the totals.

That's probably the simplest way. There are other ways, but they're more complex.