How to Sort

[Kamil]

Hi All,
I have huge amount of data in an mdb file and I want to sort it. Every day I
have to enter some data to this file therefore the sort will change. I need
to find an easier way to sort.
Can anybody tell me how to sort the table about one column.
I am new in access and I am trying to evaluate my data file. My second
question is about to create primary key. When I try to create a text field
as primary, I am getting an error message such that I have some repeating
values. I am looking for the repeating values but I can't find. Is there any
easy way to find them.
Regards...
Akdogan

 

[Allen Browne]

Answer 1: Create a query.
Use the Sorting row in query design to define the field(s) you wish to sort
by.

Answer 2: Create a query to find the duplicate values.
There's a Find Duplicates wizard in the first dialog you see when you create
a new query.

 

[Kamil]

Thank you Allen,
Now I am able to sort the data with your answer 1, but I in querry I could
not find something like "dublicates wizard". I am using Office 2003.
Regards

 

[Allen Browne]

In you can't see the wizard, you can create the query yourself like this:

1. Create a query, using your table.

2. Depress the Total button on the toolbar (upper Sigma icon.)
Access adds a Total row to the query design grid.

3. Drag the fields into the grid that define "duplicate" for you.
Accept Group By on the Total row under these fields.

4. Drag the primary key field into the grid.
In the Total row under this field, choose Count
In the Criteria row, enter:

1

The query groups by whatever fields defines a duplicate for you, and then
shows only those where the count is greate than 1 (i.e. there are
duplicates.)

 

[Kamil]

Ok Allen, I found it, thank you very much.

Answer 1: Create a query.
Use the Sorting row in query design to define the field(s) you wish to
sort by.

Answer 2: Create a query to find the duplicate values.
There's a Find Duplicates wizard in the first dialog you see when you
create a new query.