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!

Use Parameter field RANGE in Title 1

Status
Not open for further replies.

mwhager

IS-IT--Management
Jun 8, 2000
27
US
I have created a parameter field that prompts for a range value. I need to get the beginning and ending range values in a title. I have no problem getting a discrete parameter value in a title, but can't figure out how to do the range values in a title. My parameter is {?item}. So I want my title to look like:

Item Range from (beg value of {?item}) TO (end value of {?item}).

Many thanks.
 
Assumming the field is a alphanumeric field, write a formula:

"Items from "&minimum({?RangeParmField})&" to "&maximum({?RangeParmField})

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
 
Perfect - worked like a charm! I really appreciate it.
[2thumbsup]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top