update a blank field with a alphnumeric incrementing field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 97
I want to update a blank field in a table with TEXT_01 in record 1, TEXT_02
in record 2 and so forth. The text remains constant bu the number increases
by 1 for each reocrd.

Any help very much appreciated as it's very frustrating!
 
Access 97
I want to update a blank field in a table with TEXT_01 in record 1, TEXT_02
in record 2 and so forth. The text remains constant bu the number increases
by 1 for each reocrd.

Any help very much appreciated as it's very frustrating!
Click to expand...

Is the text constant (i.e. will it be TEXT_ in every record in the
database)? If so, just use a Integer field and set its Format property
to

"TEXT_"00

to *display* the prefix without storing it.

If the text is variable, you would be much better off storing the data
in two fields, a text field and an integer field. They can be
concatenated for display purposes. If they are separate values, should
the number count up from 1 to 99 for each separate text, or
independently? What do you want to happen if you hit 100 and can't
display the number in two digits?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top