Sort records while they get inserted in the table

[aman]

Hi guys

When I try to insert a record from Access form in the table then it doesn't appear in the table in the right order. E.g if it is the 6th record then it should appear in the 6th row but it appears in between other records. CAn anyone please tell me how to change the order in which records get inserted in the tbale.

Thanks

 

[vbaInet]

Open your table in Design view and also open up the table's properties. You will find where to put the field you would like to Order By.

 

[aman]

Thanks for your reply. But I can't find any sort by optionin the table field properties.


Any suggestions????

 

[John Big Booty]

Open your table in Design view and also open up the table's properties. You will find where to put the field you would like to Order By.

I think you will find find that you are looking for Order By rather than Sort By. You'll find it tenth on the list in the properties window.

 

[aman]

Thanks John. There is one Indexed property in the table and that helps to sort out the records. But what if I want to sort the records based on two fields.e.g first sort the records by Date and then by batchnumber.
e.g if there are 5 records for same date then it should sort those five records by batchnumber.

But If I set the indexed property of both the fields to Yes(Duplicates OK) then it sorts the records based on the first indexed field only.

Any suggestions????

 

[John Big Booty]

You need to open the Table's Properties window, see the attached image.

 

[aman]

John as I am using Access 2002 file format so in this Order By property is not there.... I think in that version we have indexed property instead of Order By.... Is it right????

 

[aman]

Hi John... I understood what you were trying to say. I have now sorted out the records based on two fields using Order by property in table properties.

Thanks a lot.

 

[gemma-the-husky]

it shouldn't matter which order the records show in a table. when you use the table in a query, you can specify the columns on which the table should be sorted.

if you are using tables directly, then STOP and DESIST. It is norty!


you can and should of course, add an index for sort orders you need to use regularly.