Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do i reference a calculated field in the report header?

Status
Not open for further replies.

novasian

IS-IT--Management
Jan 17, 2008
5
US
i have a calculated field which calculates the total of all balances in a column. but this field is at the bottom of the report. how do i reference to this calculation in the header of the report? i think it's possible. thanks!
 
One way:

Define a second query that returns just the totalization (one value) and use that for the header..

Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top