syntax problem

  • Thread starter Thread starter Joanne
  • Start date Start date
J

Joanne

In the query grid I am trying to set this expression to return the
first name and middle initial with a period after the middle initial

FMName: [FName] &" "& [Midinit] & ". " but the query builder is not
happy with it. I tried brackets around the ". " but that is not going
thru either.
Can you tell me what I need to do to accomplish this.
I actually have it working on full name, middle initial and last name
because there is the [LName] to end the expression, but without
something to end the expression the query fails.
TIA
 
FMName: [FName] & " " & [Midinit] & ". "

You don't have spaces on both sides of the first and second & characters.
 
Back
Top