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.

Noob needs help!

David B
in Finding & Searching

Featured Replies

  • Newbies

OK, here's my issue:

I have a FM8.5 database with over 300k records. Each record is assigned to a subject area using a "subject Area" field. The subject area field uses a drop-down list (populated from another table) of roughly 126 subject areas.

I need to figure a way to generate a report that will take the entire database as the found set, then report:

1. The total number of subject areas.

2. The total number of records assigned to each individual subject area.

I tried using the count function, but can't seem to get it to work correctly. If anyone has any pointers or knows of an example that may be relevant, I'm all ears. Thanks!

-David

Create a summary report, bsed on the Subject Area field.

As a starter, the new layout wizard thingy will lead you through the process.

Create an account or sign in to comment

https://fmforums.com/topic/54551-noob-needs-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.