V
vwillia2
I am trying to combine text in the "Control Soure" text
box to combine my [FirstName] and [LastName] fields.
When I used the expression below, I received an error
stating Microsoft Access can't find the field refered to
in your expression. Am I doing something wrong? When I
entered the expression in my training class, I had no
problem. Could there be a difference between Access 97
and Access 2002 (which I'm using now) that could cause the
error?
Here's the expression I used:
[First Name]&' '&[Last Name]
My field names do have a space in between the names so
it's not that. I also tried using quotation marks (")
instead; that was't it. I tried adding an equal sign (=);
that wasn't it? What else could it be?
box to combine my [FirstName] and [LastName] fields.
When I used the expression below, I received an error
stating Microsoft Access can't find the field refered to
in your expression. Am I doing something wrong? When I
entered the expression in my training class, I had no
problem. Could there be a difference between Access 97
and Access 2002 (which I'm using now) that could cause the
error?
Here's the expression I used:
[First Name]&' '&[Last Name]
My field names do have a space in between the names so
it's not that. I also tried using quotation marks (")
instead; that was't it. I tried adding an equal sign (=);
that wasn't it? What else could it be?