Display unbound field calculation when analyzing Access Report with Excel

[BJS]

Hi...I have an Access report that is grouped. In the group footer, I have an unbound field that calculates the total. When using the "Analyze it with Excel" from MS Access all the bound fields output with their respective field names and values into the Excel spreadsheet. I can't get it to output the proper field names and values of the unbound calculated fields. The field names out put as e.g. Text1 and the values are blank.

Any suggestions?

Thanks,
BJS

 

[BJS]

mamma mia! No help yet...please someone???? Gurus...where are you?

I've been working on this for 1.5 days so far. I have managed to get some results but not all. Here is my situation:

In the detail section of the report I have bound fields as follows:
[Week1], [Week2], [Week3] .....[Total], [Average]

In the footer section of the report I have the following unbound fields:
Sum([Week1]), Sum([Week2]), Sum([Week3])... Sum([Total]), Sum([Average])/6

When I run this report and then click the "Analyze it with Excel" button on the toolbar, all the totals from the footer section get output to Excel except the "Sum([Average])/6". This field will output fine if the control source for it is "Sum([Average]), but as soon as I add the /6 onto it, it no longer outputs.

Initiallly, I could not get the "Total" field to output but after I changed it's control source from [sum1] + [sum2] + [sum3].... to Sum([Total]), it worked.
Now, what do I need to do to get that Average field to output??????

I hope this is clear and that someone can provide some help. I sure hope I don't have to spend another day on this.

PLEASE HELP....IT IS VERY VERY MUCH APPRECIATED!

 

[lawsonium]

Hi there, did you ever get a resolution to this?

I'm having the same trouble with Total's in the Footer not appearing in the Excel output.

Anyone?

Matt