Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

  • Newbies
Posted

Hi folks:

I've inherited the training records function for a volunteer rescue squad. The program uses version 5 I guess (file extension is fp5).

I use version 4 at work, but basically I'm an Excel guy (forgiveness requested)- - - This database has over1,000 records - with about 200 members since we've been using this program. We have a myriad of bogus, incomplete, incorectly entered records.

My most pressing questions are about sorting - -

We have a field that's called List On Roster (it's a Y/N checkbox). This field seems to be able to allow the 900+ bogus records to be excluded from the results, but I seem to be unable to learn how to sort on the field.

Any help wd really be appreciated.

Replies to [email protected] or here wd be great.

Thanks

Steve

Posted

In Browse mode, Records menu, Sort command...

  • Newbies
Posted

Vaughn:

Thanks - I'm OK with the sorting part.

What I did not make clear on was that the field I want to sort on is populated by a Yes/No radio (check) button.

When I look at the field in View-List, I see essentially, the graphic of the Yes/No check box, but the program does not seem to sort on that field despite selecting it.

Hope this is more clear.

Thanks

Posted

checkbox fields sort exactly the same way as any other field. It just looks a bit different.

Your Yes/No field when sorted ascending sould sort

empty records

no

yes

It's the empty records that are probably spooking you: do any of the records have entries?

This topic is 6858 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.