Doing this gave me a result of #### in my report. I did forget to mention
that my format was text and not numeric. When I tried to change the format,
I got a "not enough space" error. I have over 33k records. I do have some
alphanumeric values as well (B1, B2). Which should be sorting first. "Duane
Hookom" wrote:

You can wrap the Floor field in the Val() function. This would also aid in
sorting since the Val() of 2 would sort before the Val() of 13.

--
Duane Hookom
Microsoft Access MVP


"Mommybear" wrote:

I have a report that is sorted by Floor, Department, then by Room. My floors
are 1-12. In order to get them to sort properly I have them in the database
as: 01, 02, 03, etc else they sort like this 1, 10, 11, 12, 2, 3, etc.

These are showing on my report as:
01, 02, 03, etc and I only want them to appear as a single digit, 1, 2, 3,
etc. I tried setting the format to ## but it still shows the leading zero.

Any suggestions.

Dawn