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

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" <(E-Mail Removed)> wrote in message
news:66D5E3A4-FA10-4B9E-A2EE-(E-Mail Removed)...
>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

Thanks Al....

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

Rob

"Al Campagna" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:66D5E3A4-FA10-4B9E-A2EE-(E-Mail Removed)...
> >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
>
>
>