Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Question regarding sorting summary records

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
0
0
I'm trying to sort some summary records.
I have a field AnswerB and then I have a field CountAnswerB which is a summary count when sorted by AnswerB.I then created a Calculation Field called GetSummaryB which is a field to get the Summary via the Summary Field
GetSummaryB=GetSummary( CountAnswerB, AnswerB)
I now want to list the answers in alphabetical order grouped together by answer.
For example:If there are 9 answers:

Congressional, Regal, Provincial, Royal, Congressional, Royal, Regal, Regal, Zebras

I want it to be ordered like this
Regal
Regal
Regal
Congressional
Congressional
Royal
Royal
Provincial
Zebras

I have it Sort the GetSummaryB first (reverse order) then the AnswerB (normal order)

Filemaker seems to have problems with this and seems to do the Alphabetical Order first, no matter what I do.
Here are the results I'd get.

Congressional
Congressional
Provincial
Regal
Regal
Regal
Royal
Royal
Zebras

Any secret sorting tips or workarounds? I'm using Filemaker 3 on a Mac!

Thanks in advance
kafclown@well.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top