sorting in desending order on access table with a lot of data

[Guest]

Hello,
I am a beginner with access and therefor my question might be a bit dumb.
I have a table in access, contains 182,256 rows of data. I need to sort by
gross sales total which is one of the columns on the table. When I select the
column and do sort in descending order, it seems to only sort 255 rows... or
so. I need all to be sorted I and I can figure it out. Can somebody help
me??? thanks.

 

[Guest]

Do not attemp to sort the table. Create a query and sort it there.

 

[John Vinson]

Hello,
I am a beginner with access and therefor my question might be a bit dumb.
I have a table in access, contains 182,256 rows of data. I need to sort by
gross sales total which is one of the columns on the table. When I select the
column and do sort in descending order, it seems to only sort 255 rows... or
so. I need all to be sorted I and I can figure it out. Can somebody help
me??? thanks.

Create a Query based on your table. Put "Descending" on the Sort row
in the query grid under this field.

Use the Query for whatever you want - it will look, feel, and act like
a Table. Tables HAVE NO ORDER - they are unordered "buckets" of data;
if you want to sort the records, use a Query.

John W. Vinson[MVP]