[AccessD] Formula fails in report

Kaup, Chester Chester_Kaup at kindermorgan.com
Fri Apr 24 10:55:08 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 on summation filed 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