Hi. I have a Report that has calculated fields in the details section. I want to total those fields in the Report Footer. When I run the report I am prompted to enter the value for the calculated fields and the Totals do not appear.
I have been scouring these forums for answers and found others with the same issue but no answers. I did see a post indicating that you can’t total calculated fields within the Report Footer. But the poster gave no further information. Like Why?
I think I know (but I could be wrong)…
Access must be inspecting the report before it actually runs. And so, since the calculated fields do not exist until the report is run then Access doesn’t find them during the inspection and hence prompts for input.
Anybody have any input on that?
Bob (Pronounced 808)