sort number by Sequence

  • Thread starter Thread starter Diane
  • Start date Start date
D

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
 
Diane said:
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, ...
Click to expand...


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])
 
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
 
Diane said:
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
Click to expand...


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
 
Back
Top