AlpahNumeric text field sort within a grouped report.

  • Thread starter Thread starter Frank's Newsgroups
  • Start date Start date
F

Frank's Newsgroups

BlankI have a report with a text field in it. Information in this field is
composed of numbers that have no alpha characters and some that do - e.g.
00005679; A03-8976; 00004589; A03-9812; etc.

Further, my report has a group footer that groups the field by using the
"Prefix Characters" option within the group properties of the sort/group
functions. That results in all the alphanumeric entries staying together and
all pure number staying together.

In this connection, I would like to sort the grouped field from lowest
number to highest number so that each group is sorted properly. What is best
way to do this?

Any assistance is deeply appreciated.

Frank
 
Frank's Newsgroups said:
BlankI have a report with a text field in it. Information in this field is
composed of numbers that have no alpha characters and some that do - e.g.
00005679; A03-8976; 00004589; A03-9812; etc.

Further, my report has a group footer that groups the field by using the
"Prefix Characters" option within the group properties of the sort/group
functions. That results in all the alphanumeric entries staying together and
all pure number staying together.

In this connection, I would like to sort the grouped field from lowest
number to highest number so that each group is sorted properly.
Click to expand...

You say you have a group on the expression
=Left(thisfield, 3)

Then, I think you want to sort on the expression
=Val(Mid(thisfield, 5))
 
Back
Top