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.

need sub summary help

cet
in Layouts

Featured Replies

  • Newbies

I have a DB listing shirt sizes and pants size for 400 records. The sizes are controlled by a value list using radio buttons. I am trying to do a sub summary showing how many of each size I need. When I do a sub summary by shirts and pants I get the following breakdown.

Shirts: YS 4 YM 6

but then I get the following breakdown for the pants:

Pants: YS 4 YS 3 YM 3

I want the pants to display as YS 7 YM 3.

I know that it has to do with my sort order but is there any way to sort by two fields consecutively?

You need two leading parts. One to contain your field Shirt/Pants. The next leading part to contain the sizes.

Sort first by shirt/pant field, then by size.

  • Author
  • Newbies

I am still not doing something correctly. I still got the same result.

is there any way to sort by two fields consecutively

Open your sort dialog. You can add as many fields as you wish and specify (per field) whether to sort ascending or descending.

Create an account or sign in to comment

https://fmforums.com/topic/32600-need-sub-summary-help/
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.