Ascending Order

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marcelino Benitez - 02 Dec 2005 03:36 GMT

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

Reply to this Message

Allen Browne - 02 Dec 2005 03:54 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>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.

Reply to this Message