Help with an expression (aka formula)

[ssanfu]

Note:
"Name" is a reserved word in Access and shouldn't be used as an object name.
Better would be "FullName".

Best would be to have two fields: "FName" and "LName". In a query you could create a calculated column "FullName: LName & ", " & FName".
I base my forms and reports on Queries, NOT tables. I have more control on filtering and sorting using a query.

[ennayram]

June7 - thank you so much! You are brilliant and I really appreciate your help. Once I realized you were talking SQL language I did some research and got it!

Regards,

MaryAnne