Problem sequencing my records

[sowms]

Hi guys!

Am able to read n write data to and from my Access Database to my VB form. When I add a new record on my VB form, it gets added to my Access Database n the record is also diaplayed on my VB form....but am not able to see the records in sequence.

Meaning, if i'm adding a record with a serial number 31... that record gets slotted inbetween my records with serial numbers 17 n 18. How can I see the records in sequence?

Help needed please!
sowms

[daveftl]

Hi guys!

Am able to read n write data to and from my Access Database to my VB form. When I add a new record on my VB form, it gets added to my Access Database n the record is also diaplayed on my VB form....but am not able to see the records in sequence.

Meaning, if i'm adding a record with a serial number 31... that record gets slotted inbetween my records with serial numbers 17 n 18. How can I see the records in sequence?

Help needed please!
sowms

use the ORDER BY clause...the sql code is like this:

SELECT * FROM <table> ORDER BY SerialNumber;

--> this will return all the records in your table in order with regards to the serial number.

hope this one answers...:)

[sowms]

use the ORDER BY clause...

Hey hi! Thanks loads it works! :)

[daveftl]

Hey hi! Thanks loads it works! :)

You're very much welcome...God bless!