Sort by date

[Morc]

I have a database in Access2000 which has a table of repair details for PCs. The database is sorted by Serial Number and then by date. I view the details from within my VB6 application by searching on the Serial Number but the records are not in date order, even though they are sorted in the right order within the original databse. Any ideas on how to do this? I've tried refreshing the databar but no joy.

 

[TonyJollans]

Hi Morc,

What exactly do you mean when you say The database is sorted by Serial Number and then by date.?

Is your table indexed on these fields? Or have you just sorted a view of it in Access? Your view from your application is independent of any view within Access (which is really just another application viewing the underlying data).

You should put an ORDER BY clause into your SQL statement in your application in order to ensure the records come in the order you want them. If you don't you will get your records in primary key sequence, but even if that's what you want it is good practice to explicitly state it to maintain independence from the physical structure.

Enjoy,
Tony