Expressions help

  • Thread starter Thread starter Randyfprf
  • Start date Start date
R

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
 
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
Click to expand...

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.
 
Back
Top