String with Varying Letter followed by Incremented Number
"Tat" wrote:
I'm new to Access and really don't even know how to ask what I need to
know, but I'll give it a shot and maybe you brilliant folks can figure
out what I mean.
....
If it can't be done in one field, is there an alternative method you
could suggest?
.
Create a table with an AutoNumber id. Let's call the field "Id". Create a
field where the user will type in a letter, lets call the field "Letter". Now
you can create a query and use a calculated field:
StudentId: [YourTable].[Letter] & Right("000000" & [YourTable].[Id],6)
Put this in the "field" field in the Query Designer.
|