Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
jeannette
 
Posts: n/a
Default Can you number a column in a database and keep it from sorting

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.
  #2   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill
 
Posts: n/a
Default Can you number a column in a database and keep it from sorting

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.


  #3   Report Post  
Posted to microsoft.public.word.tables
jeannette
 
Posts: n/a
Default Can you number a column in a database and keep it from sorting

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.



  #4   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP
 
Posts: n/a
Default Can you number a column in a database and keep it from sorting

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.





Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 04:00 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"