Expressions help

[Randyfprf]

I would like to take partial information from 3 fields and
input it into a 3rd field. something like the first letter
from FirstName, the First letter from Lastname and the
whole number from the field ClassID.
TYIA
Randy

 

[fredg]

I would like to take partial information from 3 fields and
input it into a 3rd field. something like the first letter
from FirstName, the First letter from Lastname and the
whole number from the field ClassID.
TYIA
Randy

I think you meant into a 4th field, not a 3rd field (you already have
3).
You can concatenate several fields together:
[Control4] = Left([FirstName],1) & Left([LastName],1) & [ClassID]
and display the above in a form, or a report.

There is no need to add this information to your table.
When ever you need the combined data, just use the above expression.