[AccessD] FW: Formula in Report not Calculating

Kaup, Chester Chester_Kaup at kindermorgan.com
Wed May 20 11:24:32 CDT 2009


I have a report that is based on a parameter query. The query returns from a table a week number, department number, department description and 5 fields that have an aggregate domain function of sum. When I try to put in the detail section of the report one summation field divided by another summation field all I get in print preview is #Error. I also notice that I get 4 records for each week because there are 4 descriptions for each week even though the report does not display this field. Can I not put the formula in the detail section?
Thanks.


Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799





No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.




More information about the AccessD mailing list