Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Report with Summary of two fields??

siou
in Relationships

Featured Replies

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.

Create an account or sign in to comment

https://fmforums.com/topic/18690-report-with-summary-of-two-fields/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.