insert record

Hi :

In VB Code,
I know this one,

rs.AddNew
rs.Fields("Unit") = rstemp.Fields("Unit").value
..

rs.update

But, this one is only insert the record at the end each time, what command can insert in the middle

For example:

Table1:
Unit Amount
1____$23
2____$7
3____$88

I want to insert one record:Unit is 2, Amount is $3
And put it in the 2nd row

Table1:
Unit Amount
1____$23
2____$3
2____$7
3____$88

What command I need to use? Thanks.

You should be able to cure this problem by viewing the data with a query, and have sort ascending on the units column.