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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Performing Calculations on Controls In Report

Status
Not open for further replies.

ZappaDog

Technical User
Joined
May 13, 2002
Messages
25
Location
US
I have a report based on a query that returns a single record. Lets say 5 fields are named Val1 through Val5 and appear in text-boxes txt1 through txt5. What is the proper syntax to use in controlsource property of calculated control for finding max, min, avg, etc. of the value of these controls?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top