Return to FileMaker.com
Problems with sorting in reports
I'm creating reports for a database I've just finished and regardless of whether or not I select 'sort' and 'sort ascending' for a single field on the report assistant, my records are not sorting in ascending order. Any ideas?
Are you sorting via script? Manually?
Look at the field after sorting...is there some order to it that may be explained by the field being a text field when it should be a number?
FWIW, text sorts numbers differently than numbers do...for example:
Retrieving data ...