combining text in a report field?

  • Thread starter Thread starter Linn Kubler
  • Start date Start date
L

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
 
The name of your text box is probably fname or lname. Change it to
txtFullName and the change the expression to:
=fname & " " & lname
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Null fields in a calculated field 5
One text box with Lname on second line 2
Sort text field by 2nd word 2
How to write a select statement 1
Print Same Column Headers on Two-Column Report 2
2 Concatenating Fields Showing Different Font 2
How do i create a report to be used as a form to track attendance? 3
Concatenate Question 6

Back
Top