Hi! I'm getting the following error with access. From what I could tell with the other formulas in the query, this should work.
" is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. What is wrong?
I used the template of an existing field to put this one together. I'm looking for it to become an email address.
User Name: [Left(staff.FirstName,20)& (".")&Left(staff.LastName,20)&("@valleycentralschools.org")]
What I have tried:
User Name: [Left(staff.FirstName,20)&(".")&Left(staff.LastName,20)&("@valleycentralschools.org")]