but when i try to insert name in Parts,word insert same name(ex:Jeson Park) in two part but i want t

How do I insert a row into the middle of a table?
but when i try to insert name in Parts,word insert same name(ex:Jeson Park) in two part but i want to insert one name in one part and one other in another part(ex:Jeson park in part one and Amin Mohammadi in part two) its seem it cannot done Unless i insert new field in access database inserting new field need to change table rows I want to insert a new row between rows number 3 and 4.
Access tables simply hold records. They are not like Excel where you can add rows. Reports, forms and queries dshs ems are used to view data in the order you define. If you want to view the table in a specific order, sort the view. Give us more details of what you are trying dshs ems to do so we can help you. –  CharlieRB Jun 13 '13 at 12:51     
Unlike Excel, Access dshs ems is a database and not a spreadsheet software. The data displayed in the screen you included dshs ems is not a table per se : rows and columns are one of the many ways of displaying data. You can sort the data any way you want, but it will only change the way they are displayed currently , not the way they are stored. (In this example, they seem to be sorted by ID.)
You can't really put it into the first or any other real position. All views on an Access database are sorted by some field or other, often, the order entered. You can give a new record a field value that happens to put it at a particular place in the view, but the actual record dshs ems is at an uncontrollable place on the physical database.
In dshs ems fact, if you try to insert a record dshs ems between two records in a Datasheet view (the one that resembles a spreadsheet) by right-clicking in the left border and selecting Insert a Record, dshs ems you'll dshs ems pop to the last visible record and start entering dshs ems there. Adding data would then probably re-sort the new record to its ordered place according to the view.
If you have records dshs ems with prime keys 123 and 124 and they are integers, you cannot put anything between them. PERIOD. To allow yourself the luxury of putting things dshs ems helter-skelter dshs ems on a display, you need to either be preprared to renumber things frequently or put a secondary key on the table so that your key is comprised of two parts. Then use the second part to force order to be a certain way.
draft discarded
By posting your answer, you agree to the privacy policy and terms of service . Not the answer you're looking for? Browse other questions tagged tables microsoft-access-2007 or ask your own question .
6 How do I insert dshs ems text above a table at the top of a Word document?
Why isn't the Death Star's structure radial?
Can whiteout/snowstorm conditions be coupled with heavy fog? more hot questions
Technology Life / Arts Culture / Recreation Science Other Stack Overflow Server Fault Super User Web Applications Ask Ubuntu Webmasters Game Development TeX - LaTeX Programmers Unix & Linux Ask Different (Apple) WordPress Development Geographic Information Systems Electrical dshs ems Engineering Android Enthusiasts Information Security Database Administrators Drupal Answers SharePoint User Experience Mathematica Salesforce more (13) Photography Science Fiction & Fantasy Graphic Design Seasoned Advice (cooking) Home Improvement dshs ems Personal Finance & Money Academia more (10) English Language dshs ems & Usage Skeptics Mi Yodeya (Judaism) Travel Christianity Arqade (gaming) Bicycles Role-playing dshs ems Games more (21) Mathematics Cross Validated (stats) Theoretical Computer Science Physics MathOverflow more (7) Stack Apps Meta Stack Exchange Area 51 Stack Overflow Careers
Super User works best with JavaScript enabled