Report with Summary of two fields??

[siou]

Hello. I am working on a filemaker system for people who make clothes.

I need to make a report that can lookup values from more than one field, and then return a report that summarizes values from two or three fields in one report, separated by colors, and sizes.

For example:

I will have a report for the amount of zippers used for producing a total order.

In the main database, the user enters the amount of zippers used in two separate fields.

This is because sometimes you need to use more than one zipper to make an item of clothes. I however need to do a production report when someone orders multiples, and then my report needs to look up all the instances when ZIPPER 1 is used in field one, and also in field two, and summarize these on one report subtotaling by color.

oh, i am super stuck on this, and I have to finish soon, so please if you have any ideas for help...i would really appreciate it.

Thank you.

[Vaughan]

duplicate post