Header text box results from a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a report that displays electrical devices in a building by
floor. The floors are displayed based on the first number working inward
towards the decimal point, so it looks like 10, 11, 12, 13, 14, 15, 16, 17,
18, 19, 1, 20, 21, 22.... etc. I would like it to appear in number order
from 1 ascending, but placing the single digit numbers in the right place.
Any ideas?
 
I've created a report that displays electrical
devices in a building by floor. The floors are
displayed based on the first number working
inward towards the decimal point, so it looks
like 10, 11, 12, 13, 14, 15, 16, 17, 18, 19,
1, 20, 21, 22.... etc. I would like it to appear
in number order from 1 ascending, but placing
the single digit numbers in the right place.
Click to expand...

Your number is, apparently, stored in a Text Field, and properly sorted for
text. In the Query that you use for the RecordSource of the Report, include
a calculated Field, in which you convert the pertinent part of that value to
numeric... CInt, CSng, CDbl are built-in functions for that purpose. Sort on
the numeric Feld instead of the Text Field

Larry Linson
Microsoft Access MVP
 
Back
Top