Exporting Access Report to Excel Spreadsheet producing strange results

[Rickochezz]

When I attempt to convert access report to excel spreadsheet



DoCmd.OutputTo acOutputReport, "rptProvExamList", "Excel97-Excel2003Workbook(*.xls)", "P:\Training\Training Database\Exam booking form2.xls", True, "", , acExportQualityPrint

This
=[LastName] & ", " & [FirstNames]

produces

Student Name

ARIF, Imran

AYODELE, Ebenezer

BHANSORA, Sanjay Singh

BHANSORA, Sanjay Singh

BHANSORA, Sanjay Singh

BHANSORA, Sanjay Singh

BHANSORA, Sanjay Singh

BHANSORA, Sanjay Singh

BHANSORA, Sanjay Singh

BHANSORA, Sanjay Singh

and when I right click one of the cells I get the option to "Pick from drop down list" with the first 3 entries being the possibilities

If I just use
=[LastName]

I get all of the correct last names

Thinking that this is an easy fix but over my head

Any assistance would be greatly appreciated

Thanks
Rick

[ItsMe]

I can only guess that you are using a lookup field at the table level in your Access DB.

[Rickochezz]

They are both just "short text" fields within the student table and just trying to bring them together in the report separated by a comma and space

[Rickochezz]

You might be on to something

When I use just

[FirstNames]

I get the same result

So, any ideas on how to troubleshoot and eventually come up where the problem lies (other than between the chair and the keyboard)

[ItsMe]

Are you exporting from a table or a query? When you look at the table in design view, and you look at the properties for the name fields, is there anything in the Lookup tab? The General tab will have the focus on default, so click the Lookup tab for the Properties at the bottom of the window.

[Rickochezz]

I'm actually exporting a report which gets its data from a query

Lookup tab
Display Control - Text Box
That is all

[ItsMe]

OK, you did mention that and I should have stayed focused on that. Reports have groups, so, stuff gets repeated. Similar stuff can happen with queries. However, reports are often times difficult to comprehend when they are exported to Excel. I would start by exporting from the query your report is based upon. You may want to make a copy of the query and make some changes in the end.

[Rickochezz]

I will try that - Thanks

[ItsMe]

You bet, let us know how it turns out.