Ascending Order

  • Thread starter Thread starter Marcelino Benitez via AccessMonster.com
  • Start date Start date
M

Marcelino Benitez via AccessMonster.com

I have a report by cmpany name and Drawer number. i want to order the
drawers number but the problem is the following. The order is by number like
this 1, 10, 11, 111 and I want it like this 1, 2 3, 10, 11, 100 how I can do
it like the correct way. Thanks in advance.

Marce
 
Open your table in design view.
Select the Drawer number.
Change it to a Number field instead of a Text field.

The numbers will then sort correctly.
 
Back
Top