Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Sorting By Summary Fields

Sorting By Summary Fields

Sorting By Summary Fields

Hi does anyone know how to get round this on Filemaker 8 ?  I have a set of results displayed in a report which is currently sorted by Salesperson.   Each salesperson has a 'call value'  which is a calculation derived from the no of calls taken and total overall sales value.  What I want to do is sort them as in a 'league table' of 'call value'.  As the field is a summary field it's not available to be chosen to 'sort by'..... is there any way around this or does filemaker versions above 8.03 allow this to be done ?..... thanks in advance guys

RE: Sorting By Summary Fields

I usually create an extra field (NewSum) in the same table, which duplicates the Summary.

Define it as Calculation and equal it to the Summary field :NewSum = Summaryfield
You can sort on that new field as it will reflect exactly the summary field.
Even FM 9 does not allow you to sort on Summary felds.

If 'something' 'somewhere' gives 'some' error, expect random guesses or no replies at all.
Free Tip: The F1 Key does NOT destroy your PC!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close