insert a row in table

V

vineet_link

i want to insert a row in a tablle but when i insert this it automatically
goes to the bottom of the table , if i want to insert a row on between 23 and
24 row how can i insert , i am a biginner of access cane any body help me.

thanks

vineet
 
L

Larry Daugherty

You have no control over the placement in the table. FYI, a table is an
unordered bucket of data and it's Access/Jet's job to take care of business
there. You can write queries on the table to retrieve its data in any
order, or to modify it or to delete it.. Most usually, you will use Forms
to enter and display data and trust that the Relational Database Management
System is doing its job. Using forms you have a great deal of control over
your data.

One huge caveat: Always use forms for massaging data. Don't muck around in
the tables directly and definitely do not require or even let your users see
the tables.

HTH
 
Top