I would like to set up a database where I have a number column so that when I
print the database it would print next to the last name and I would know how
many are there without have to go to the dataform each time. As I add new
names and sort the name column the number colunm sorts with the rest of the
database and defeats my purpose. Is there any way to get around this.

Use an autonumber or SEQ field.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"jeannette" wrote in message
news
I would like to set up a database where I have a number column so that
when I
print the database it would print next to the last name and I would know
how
many are there without have to go to the dataform each time. As I add
new
names and sort the name column the number colunm sorts with the rest of
the
database and defeats my purpose. Is there any way to get around this.

Thank you Suzanne but I have not use SEQ fields before and I need more
instructions on how to use them. I have gone to insert, got as far as
Captions then I am lost.

"Suzanne S. Barnhill" wrote:

Use an autonumber or SEQ field.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"jeannette" wrote in message
news
I would like to set up a database where I have a number column so that
when I
print the database it would print next to the last name and I would know
how
many are there without have to go to the dataform each time. As I add
new
names and sort the name column the number colunm sorts with the rest of
the
database and defeats my purpose. Is there any way to get around this.

From the Insert menu, select Field, and then select the Seq item from the
list and in the adjacent Field codes control, add an identified (any word
will do) to be used to uniquely indentify this series of fields. After
inserting one, in this manner, the easiest way to insert the others is to
use copy and paste and then select them all and press F9 to cause the fields
to update.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"jeannette" wrote in message
...
Thank you Suzanne but I have not use SEQ fields before and I need more
instructions on how to use them. I have gone to insert, got as far as
Captions then I am lost.

"Suzanne S. Barnhill" wrote:

Use an autonumber or SEQ field.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup
so
all may benefit.

"jeannette" wrote in message
news
I would like to set up a database where I have a number column so that
when I
print the database it would print next to the last name and I would
know
how
many are there without have to go to the dataform each time. As I add
new
names and sort the name column the number colunm sorts with the rest
of
the
database and defeats my purpose. Is there any way to get around this.