Mailing Label Titles

[Spuds]

I have imported a database from Excel containing name and address information. The database has two fields for the name (One for the first name and one for the last). When I try to develope a report with the mailing labels containing both name fields, instead of displaying the first and last names, it displays the report title, followed by the last name. (Example: Out of State Labels Bell instead of Thomas Bell) If I build the report with only the first or only the last name, the labels appear to be correct. I have looked at everything on the back end and can't seem to find a cause for the error, but I'm also very new to this. I am assuming that the error occured on the Excel side, since the sample database produces labels that are correct.

Does anyone know what is causing this error and how I can fix it?

Thanks for your help,
Michelle

 

[Rickster57]

label report

Morning,

If you are using a query where the expression is called name:[firstname] & " " & [lastname]...this will give the problem you are seeing. Call it something like fullname:[firstname] & " " & [lastname]. Interestingly, I have only seen this in label reports.

Hope this helps.