sort number by Sequence

[Diane]

I am using access 2003. Please help

I have to make a report by page number sequence, 1, 2, 3, 4, 5...
Ascending will list my number 1, 11, 101, 111,... 2, 22, 201, ...

Please help. many many thank

 

[Marshall Barton]

I am using access 2003. Please help

I have to make a report by page number sequence, 1, 2, 3, 4, 5...
Ascending will list my number 1, 11, 101, 111,... 2, 22, 201, ...

Your numbers are text values, not numeric values so they are
sorting in "dictionary" order.

Try setting the report's Sorting and Grouping to an
expression like:
=Val([your number field])

 

[Diane]

Thank you Marsh

You fixed my first problem. Here is the second problem, please help. This is
the report for magazine pages. In the report, my boss wants to have all the
odd page number on left side and all even page number on right hand side. the
report page layout is like this

customer page# page size color/B&W customer page# page size color/B&W

Thank you very very much for helping me

 

[Marshall Barton]

You fixed my first problem. Here is the second problem, please help. This is
the report for magazine pages. In the report, my boss wants to have all the
odd page number on left side and all even page number on right hand side. the
report page layout is like this

customer page# page size color/B&W customer page# page size color/B&W

If all the pages for a customer fit on one page of the
report, then set Sorting and Grouping to:
Customer
=1 - (Val([Page #]) Mod 2)
=Val([Page #])

Set the Customer group header section's ForceNewPage
property to Before Section

Set the second group header's NewRowOrCol property to Before
Section