Access the answers to your technology questions today.
Subscribe Now
30-day free trial. Register in 60 seconds.
What Makes Experts Exchange Unique?
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
Subscribe Now
30-day free trial. Register in 60 seconds.
Join the Community
Give a Little. Get a Lot.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Join the Community
by: ast2550Posted on 2007-11-09 at 13:05:14ID: 20253051
What?
This should be a piece of cake.
New Report
Add Table (MyTable)
Report | Select Expert
Choose either the FromNumber or ToNumber
Then click 'Show Formula' and then 'Formula Expert'
Enter (pick them from the window above versus typing the field names)
525 > {MyTable.FromNumber} And 525 < {MyTable.ToNumber}
Click OK
Then, when you want to get fancy, create a parameter field for the input of the 525 and then alter your Select Expert formula to be:
{?Parameter} > {MyTable.FromNumber} And {?Parameter} < {MyTable.ToNumber}