Unable to resolve report page break issue.

[soap]

Good day team,
Please i need help on how to resolve an issue on my report. The report querry is coming from a querry generated from main and subform. The report page fails to break in to another page whenever the data value generated from the subform is more than 10, it rather start numbering 11 and 12 from the top. I have but no solution.
I need a possible VBA script that can create a page break whenever the value is more than 10.
Find below a screen shot of the result that i am getting.

https://snag.gy/tquoWJ.jpg .

Thanks in advance for your assistance.

 

[isladogs]

The sort order for your Item No field makes no sense

If your Item No field is in fact a text field it should go in order 1,11,12,2,3 ...rather than numerical order

Yours does neither of those. Is there something 'special' that you've done?

 

[soap]

The numbering should be sequential after the 10th value. The report page is expected to break to another page instead of recycling the value to the the top.
this is the design view https://snag.gy/etYKMO.jpg

 

[isladogs]

Sorry the design view gives no clues.
Is it text or number?

You'll need to check the record source, report grouping and any relevant code

 

[soap]

Sorry the design view gives no clues.
Is it text or number?

You'll need to check the record source, report grouping and any relevant code

It is a number.

 

[Cronk]

The order that data appears on a report is not determined by the query sort. It's necessary to set the order in the report.


You need to go to the bottom of the screen when the report is in design view and add a sort.

 

[soap]

I just discovered that the disorder is coming from my subform value which users enter manually. After the 10th value the the next values starts from the top as seen in the image shared before. How can get this sorted please?
https://snag.gy/wLhOCM.jpg

 

[Gasman]

Make [Item No] a numeric field and not text?

 

[isladogs]

If you look back to my first reply, the values are being sorted 'alphabetically' as text. You need to identify why & sort as numbers

 

[soap]

I have fixed the issue, it was coming from the subform value which was not a number but a text not properly sorted. Thanks everyone