This is just to share it with you. I am using Access 2000 and when I am using reports to join two fields I get an error #Error. The problem seems to be that the NAME of the control matches one of the names (fields) from the table/query. Eg.<br>
<br>
Lets say we drag a field called Lastname to our report. The control with the same name is created (textbox). Now we want to add Firstname to it so it is a Full name. So for the Control Source we would add<br>
=[Lastname] & ", " & [Firstname]<br>
<br>
When previewing the report it shows #Error, what you have to do is to change the name of the control which contained the field name Lastname into something else, like Fullname.
<br>
Lets say we drag a field called Lastname to our report. The control with the same name is created (textbox). Now we want to add Firstname to it so it is a Full name. So for the Control Source we would add<br>
=[Lastname] & ", " & [Firstname]<br>
<br>
When previewing the report it shows #Error, what you have to do is to change the name of the control which contained the field name Lastname into something else, like Fullname.
