I have a report named rpt_Labor_Report. Here is the structure:



-Report Header

-Page Header

-tbl_Division_Division Header

-tbl_Subdivision_Subdivision Header

-Entry Header

-Detail

-Entry Footer

-tbl_Subdivision_Subdivision Footer

-tbl_Division_Division Footer

-Page Footer

-Report Footer



Here is the problem.  I do some calculations on a field in the Entry Footer

section.  That works great.  I need to be able to sum the values from text1

in the Entry Footer section in the tbl_subdivision_subdivision section.  I

am having no luck.  I tried the fully qualified name, ie,

=sum([reports]![rpt_Labor_Report].[text1]) and I just get a blank.  How do I

sum this field?



Help!!!!





John Pace

Manager of Information Technologies

Haws and Tingle General Contractors

650 West Vickery Blvd

Fort Worth, TX  76104

xxx-xxx-xxxx

Fax:   xxx-xxx-xxxx

E-Mail:  jpace@h...

www.hawstingle.com

John, I had this problem once,  I think the issue is that you have to add 

the total from the report footer.  Try that and see if it works.  Good 

luck -