Jump to content

Report with Summary of two fields??


siou

This topic is 7570 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

This topic is 7570 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.