Sort Database

[Guest]

I have compiled a list of IP's used at our office. My table consist of five
fields, the key field is the IP address's. When I print or even look at the
Data on the computer, the first page is in numarical order, the other pages
are not. My question is, how do I get the entire data table sorted?? I am
using Access 2003, and I am entering the IP's like this, 10.16.169.325.

 

[Rick B]

Tables are not in any particular order. They are simply a place for the
data to be stored.

To PRINT, you would build a report. You can specify the sort in your
report.

To EDIT or ENTER data, you should be in a form.

Both the form and the report should most likely be based on a QUERY.

You should almost never work in a table once you get the structure built.

 

[Rick Brandt]

I have compiled a list of IP's used at our office. My table consist
of five fields, the key field is the IP address's. When I print or
even look at the Data on the computer, the first page is in numarical
order, the other pages are not. My question is, how do I get the
entire data table sorted?? I am using Access 2003, and I am entering
the IP's like this, 10.16.169.325.

That is a text entry and it is going to sort as text. If you want a
numerical sort you either have to enter all of the padded zeros for each
"section" or store each part of the IP address in a separate numerical
field. Otherwise in a query you could add calculated fields that pull each
section out as a number and then sort on those calculated fields.