Joining report fields (1 Viewer)

[quilisma]

I need to combine text values from multiple fields on a report, which, according to the Help file, should be entered:
=[FName] & " " & [LName]
in order to yield something like: Terry Jones. I get nothing but #error messages on my reports. What am I doing wrong?

 

[llyal]

If you are new to report design, make sure the Name of the field is different than the Control Source; because of the way Access defaults when making reports, it makes these two properties the same and this can cause problems;

You may need to describe your report in more detail if you still need help;

 

[quilisma]

That fixed it - Thanks so much. I've been knocking my head against a wall for days on this. You have no idea what a relief this is.