combining text in a report field?

[Linn Kubler]

Hi,

I'm relatively new to Access, using Access 2000. I have a simple table with
a few fields. The two fields in question are fname and lname, both text.

I'm creating a report and I want to concatenate the fname and lname into one
field I'm calling "name".

I added a text box to my report and typed the following in it: =fname &
lname. (that gets translated to: =[fname]&[lname].

When I preview the report I get "#error" in that field.

Any suggestions? Am I doing something wrong in my syntax? If I simply
enter lname or fname it works fine but it doesn't like combining them.
Help!!

Thanks in advance,
Linn

 

[Duane Hookom]

The name of your text box is probably fname or lname. Change it to
txtFullName and the change the expression to:
=fname & " " & lname