Sort will only sort text from smallest to largest?

[Gotoknow]

Hi,

Trying to sort a report by 3 fields. 1st by a text field that should sort A
to Z, then by a number field that should sort smallest to largest, then by a
3rd number field that should also sort smallest to largest. However the only
options offered are backwards. It is offering me a choice of smallest to
largest for the text field, and A to Z for the number fields. How do I
correct this? Currently I'm trying to do this in the Group, Sort, and Total
area shown at the bottom of my report when it is in design view. Using Access
2007. Appreciate your help.

 

[Allen Browne]

The options for sorting in the Sorting And Grouping box in Access 2007
depend on the data type, e.g.:

Data Type Sorting offered
======== ===========
Text With A on Top
Date From oldest to newest
Number From Smallest to Largest
Currency From Smallest to Largest
Yes/No From selected to cleared

If you are seeing the types muddled, it indicates that Access understands
the fields differently than you do. This can happen where you have a query
as the source for the report, and you have expressions in the query. The
solution is then to change the expressions so Access understands the types
correctly.

Here's some info on that:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

And some more advanced suggestions:
Common query hurdles
at:
http://allenbrowne.com/QueryPerfIssue.html

There are other reasons why Access my interpret the data types differently
than you expect. For example, if you are using an attached Text file or
Excel file where there is no strict data typing.

 

[Gotoknow]

It worked. I had some of the text files messed up.
--
Thank you,
Gotoknow

The options for sorting in the Sorting And Grouping box in Access 2007
depend on the data type, e.g.:

Data Type Sorting offered
======== ===========
Text With A on Top
Date From oldest to newest
Number From Smallest to Largest
Currency From Smallest to Largest
Yes/No From selected to cleared

If you are seeing the types muddled, it indicates that Access understands
the fields differently than you do. This can happen where you have a query
as the source for the report, and you have expressions in the query. The
solution is then to change the expressions so Access understands the types
correctly.

Here's some info on that:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

And some more advanced suggestions:
Common query hurdles
at:
http://allenbrowne.com/QueryPerfIssue.html

There are other reasons why Access my interpret the data types differently
than you expect. For example, if you are using an attached Text file or
Excel file where there is no strict data typing.