Export to excel doesn't take over calculations

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Hi,

I have a form called "Project" where for every project we have, an overview
is calculated with participants, statistics etc...
This calculation is made with simple formulas like.
nnz(Subform36.Formulär!Total26)

This works great but now I would like to export this information for all
projects with these numbers as well.
When exporting the form to excel, it gives me all info except that it only
calculates the data/statistics for the first record/project.

How can I make it calculate the data for all and still export it to excel?

Any suggestions are welcome.

Thanks
 
A little more details may be needed.

For starter, do you want the calculations to occur in Excel or in Access?

Secondly, how are you currently exporting the data?
 
You probably need to write a query and have the calculations in the query
(based on related data in the other tables or actual dlookups in the query
itself), then export the query via code after you press a button etc....

You calculations only work because on the main form you are moving to a new
record and then you see the new calculation.

HTH,
Mark
 
Mark,
Well, you're probably right, but it seems like it will be such a complicated
query... I'll try and let you know.

Banana, the calculations are made in ACCESS but I want them to be exported
in an excel sheet.
I tried exporting with Docmd.outputto


Thanks for your help
 
Back
Top