I am receiving an error message on my expression...this is what I have
SELECT)[Implant Oper UPIN),(LName&","&[FName]
and the error message is saying this..Compile Error Expected: Line Number or
label or statement or end of statement...please someone help me with this.
Well, I can see why it's complaining. It is completely incorrect. It
sounds like you're trying to put this into some VBA code (you don't
say where), but it's apparently an attempt to write the SQL statement
of a Query. Note that it always helps to explain not only *what* you
entered, but *where* you entered it!
Try creating a new Query. Base it on whatever table you're trying to
use (bear in mind, we don't know your table or fieldnames). Include
the [Implant Oper UPIN] field (which I'm guessing is the name of a
primary key field in your table...?
In the next column of the query grid, in a vacant Field cell, type
FullName: [LName] & ", " & [FName]
just exactly that way - the spaces are meaningful.
John W. Vinson[MVP]
