sorting a numeric column in a report

[cougartrace]

Hi all,

I have a report where I have 5 headings. I group by Title and then I sort by Number after this. However, if I have numbers 110,220,50. The 50 comes last instead of 1st. How do I fix this?

 

[GoDawgs]

Seems like your "number" field is actually text. In the sorting and grouping box add a CInt to that field:

CInt([TheField])

Hope that helps.

Kevin