Error Message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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