Sort database

[gcmNTS]

I have a large database with about 4 million records, but only 7 fields per
record. Can an access database be sorted? A query takes too long to use as a
sorting method. I get errors if I try to create new index fields.

Thanks,
Gene Mathis

 

[Mirobot]

If you are talking about sorting a table, you can use the
AZ(down) and ZA(down) buttons, but queries are designed
for organizing and sorting records, and calculating
values.

 

[John Vinson]

I have a large database with about 4 million records, but only 7 fields per
record. Can an access database be sorted? A query takes too long to use as a
sorting method. I get errors if I try to create new index fields.

A 4-million row table is pretty big, but well within Access'
capabilities. Sorting will only be efficient if the field you're
sorting on is indexed, however!

What errors are you getting? What indexes do you currently have on the
table? Use View... Indexes in table design mode to see.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps