Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I got two pieces of A4 paper in ms word
Two parted A4 paper
i want insert 2 name in each part using Mail Merge wizard

I create the following table in an Access database:

enter image description here

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.

Is there a way to insert a row into the middle of a table OR Insert two Different row in same word page?

share|improve this question
4  
Access tables simply hold records. They are not like Excel where you can add rows. Reports, forms and queries 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 to do so we can help you. –  CharlieRB Jun 13 '13 at 12:51
    
tnx For replay .i give more detail about my wonderful table!!! –  Jeson Park Jun 13 '13 at 12:53
add comment

1 Answer

up vote 3 down vote accepted

Unlike Excel, Access is a database and not a spreadsheet software. The data displayed in the screen you included 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 is at an uncontrollable place on the physical database.

In fact, if you try to insert a record 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, you'll pop to the last visible record and start entering there. Adding data would then probably re-sort the new record to its ordered place according to the view.

(source)

You must stop immediately and forever in thinking "rows" when working with Access. They are not rows.

If you have records 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 helter-skelter 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.

(source)

To add new data between "3" and "4" you'd have to modify EVERY data after "3" and increment its ID, and then insert a new data with ID being "3".

share|improve this answer
add comment

Your Answer

 
discard

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 or ask your own question.