Report Sorting question

  • Thread starter Thread starter Darby Holmes
  • Start date Start date
D

Darby Holmes

I have a Grouping on 'ID' with the value assigned
to 'ascending' and the report generates:

118
342
62
77

I assume the engine is treating 62 like 620 and 77 like
770, but I'm not sure. Any suggestions on how to get
these in numerical order?

Thanks
 
Darby,

Your fields are likely Text type. Text fields (even if they have a meaning
which is numeric) do not sort on the perceived numeric value, rather each
character is evaluated for sorting purposes.

In the query which underlies your report, create a calculated field as
follows:

SortID: Val([ID])

Then, in your report, use that field for your Grouping.

hth,
 
Cheryl - perfect, you're the best!

Thanks!!
-----Original Message-----
Darby,

Your fields are likely Text type. Text fields (even if they have a meaning
which is numeric) do not sort on the perceived numeric value, rather each
character is evaluated for sorting purposes.

In the query which underlies your report, create a calculated field as
follows:

SortID: Val([ID])

Then, in your report, use that field for your Grouping.

hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

I have a Grouping on 'ID' with the value assigned
to 'ascending' and the report generates:

118
342
62
77

I assume the engine is treating 62 like 620 and 77 like
770, but I'm not sure. Any suggestions on how to get
these in numerical order?

Thanks
Click to expand...


.
Click to expand...
 
Thank you and good luck with your project.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Darby Holmes said:
Cheryl - perfect, you're the best!

Thanks!!
-----Original Message-----
Darby,

Your fields are likely Text type. Text fields (even if they have a meaning
which is numeric) do not sort on the perceived numeric value, rather each
character is evaluated for sorting purposes.

In the query which underlies your report, create a calculated field as
follows:

SortID: Val([ID])

Then, in your report, use that field for your Grouping.

hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

I have a Grouping on 'ID' with the value assigned
to 'ascending' and the report generates:

118
342
62
77

I assume the engine is treating 62 like 620 and 77 like
770, but I'm not sure. Any suggestions on how to get
these in numerical order?

Thanks
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top