Question Replace Text with actual totals in MSAcces

[amunafc]

Hi Guys

I have re-uploaded the database with few field names. Please download, unzip and open it. then run the report and export it to an excel or analyze it with excel. You will notice that the totals in the spreadsheet are not showing. it is only showing the following. Is there any way in MS Access of showing the totals rather than the text?

Text120:70,000,000.00Text121:30,000,000.00Text130:Text145:70,000,000.00Text146:30,000,000.00Text155:Text158:70,000,000.00Text159:30,000,000.00Text168:

 

[wiklendt]

looks like the totals are still there in the excel sheet.

the "text146" etc that you are seeing is what you have called the report controls (textboxes). give them a sensible name, and the excel export will be sensible too.

 

[georgedwilkinson]

Is there a reason you're not exporting directly to Excel?