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

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Sorting Data fields within a single record

Followers

March 5, 200421 yr

Greetings,

I have been tasked with creating a new mutual fund profile in a relational dbase format and I have completed about 90% of this project. My last problem is dealing with sorting sector data per mutual fund(as you will see in the attachment) and displaying the top 5 sectors. The issue lies in how the data is exported from Principia (financial software). Each sector (from the raw data) is turned into its own field on import. It would be easier if I could just have a generic sector field and then each type of sector (Energy, Utilities, Telecom . . .) be its own record. Sorting would be a snap then. BUT, I am curious to know if there is a way to sort, or rank, the sectors according to the top 5 WITHIN a single record.

This data will be displayed in the join table or Fund Profile.

Any suggestions would be greatly appreciated!

Jon

SectorData Converted.zip