string expression repeating in report exported to excel
My report has several grouping levels (headers) before the detail section. The detail section contains the following fields; ID, Name, Email. The problem I am having is that when I export the report to excel, the "Name" field is repeating the record of the first row of the detail.
In other words, it looks like this.
ID NAME EMAIL
001 Smith, Tom tomsmith@email
002 Smith, Tom marybaker@email
003 Smith, Tom jimjones@email
The control source of the Name field is = [Last Name] & ", " & [First Name] which is causing the problem. If I include the First Name and Last Name fields separately it is fine.
Any ideas why this would be? For space constraints I really need to concatenate this field.