how to cancat a string with a number field (1 Viewer)

hello

i have a table and i want to have the id of this table as :

ST_1
ST_2
ST_3

i mean ST_automatic number

i want to know how i can create it
is it possible to set the first value of auto number field in ms access?
also it is ms a ccess web database?
thank you for oyur help

No, autonumber is AUTO. users cant do nuthin to it.
You can make a blanket update query to create your ID , but I dont see the need.
(autoumber ...duh)

Instead of using the table for your work, from now on use a query qsTable, that builds this ID on the fly...
so the first field would be:
"ST_" & [IDNUM] as CoID

Then Answer to,

mana said:

is it possible to set the first value of auto number field in ms access?

Click to expand...

by,

Ranman256 said:

No, autonumber is AUTO. users cant do nuthin to it.

Click to expand...

is not entierly TRUE, you can "reseed" autonumbers. Yes, it is possible. However then process is a tad tedious and not highly recommended. Although, I am convinced that there is no need to actually store such values unless otherwise necessary.

I do not actually follow your question here,

mana said:

also it is ms a ccess web database?

Click to expand...

If the question was, Is Access a Web Database, the answer is NO. Access is a normal Front end to the JET DB Engine. However if your question were to be Can Access be used as a Web DatabaseThe answer is yes.

hello
thank you for your reply
but do you know how i can save this as a sentence in a field as text?
is EPM info st_[fieldid] implemented
thank you for the response