If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Record number in Mail Merge
I want to use an Autonumber field as my Record Number instead of the Access
Table Record number. The starting value for the Autonumber field is 400, which is Access Table record 1. When I perform a Mail Merge to a Word document I have to select the Access Record Number rather than a record using the Autonumber field, i.e i have to enter record no.1 in the mail merge query box rather than 400 as I want to. Is there a way to alter the record number in access to reflect the Autonumber field? Any help appreciated!! |
#2
|
|||
|
|||
The record number and autonumber fields are not to be used by the end user.
They are internal controls only. If you want a useable number, create one. Make a field called CustomerNumber or EmployeeNumber or similar. Enter the value you want in the field. Rick B "TP" wrote in message ... I want to use an Autonumber field as my Record Number instead of the Access Table Record number. The starting value for the Autonumber field is 400, which is Access Table record 1. When I perform a Mail Merge to a Word document I have to select the Access Record Number rather than a record using the Autonumber field, i.e i have to enter record no.1 in the mail merge query box rather than 400 as I want to. Is there a way to alter the record number in access to reflect the Autonumber field? Any help appreciated!! |
#3
|
|||
|
|||
Note. The post two entries below yours with the topic "Autonumber lost its
sequence" explains further what autonumbers are used for. Rick B "TP" wrote in message ... I want to use an Autonumber field as my Record Number instead of the Access Table Record number. The starting value for the Autonumber field is 400, which is Access Table record 1. When I perform a Mail Merge to a Word document I have to select the Access Record Number rather than a record using the Autonumber field, i.e i have to enter record no.1 in the mail merge query box rather than 400 as I want to. Is there a way to alter the record number in access to reflect the Autonumber field? Any help appreciated!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I maintain number formatting in a mail merge? | Skittles | Mailmerge | 1 | January 28th, 2005 03:22 AM |
How to choose your own record deliminators in mail merge? | GMed | Mailmerge | 1 | January 22nd, 2005 12:44 AM |
Mail Merge - Next Record | MH IPD | Mailmerge | 1 | August 25th, 2004 09:55 AM |
Total number of pages in mail merge document per document | Ava Healy | Mailmerge | 1 | May 27th, 2004 06:50 AM |