View Full Version : Joining report fields


quilisma
08-25-2000, 01:16 PM
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
08-25-2000, 02:21 PM
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
08-25-2000, 03:06 PM
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.