"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.