Sort Order Issue

[Rob]

I have searched through the posts and haven't seen a question or response
that will help me with what I am doing here.

I have a subreport that I am looking to sort by an assigned Line Number .
The problem is that when the report is longer than 10 lines, the numbering
gets skewed. The numbering susyetm is how our main Financials system
generates the Order lines. They do it in increments fof 10000 with the first
line being numbered 10000, the second is 20000 and so on. Once it hits 10
lines, it jumps to 100000 and so on. The problem is that when the report is
generated, the number goes and starts at 10000 and then the next line is
100000 and the next one is 110000 . So it is grouping it by the first number
only.

I have tried setting the Group Interval in the Sorting and Grouping area
and still am unable to get the report to look as it should.

I am hoping someone may have a solution that I might try.
Thanks
Rob

 

[Al Campagna]

Rob,
It appears as though that field is text. Can't be sure, but try...
Val(LineNumber)
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Rob]

Thanks Al....

That was the problem.... Works as it should now..

Rob