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