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

Variable in record selection.

Status
Not open for further replies.

scon165

Technical User
Dec 27, 2001
7
US
Can a variable be used in record selection? I have a report that is calculating workdays and holidays based on the formula from Ken H. and is working correctly. However I want to limit my record selection based on the formula. Please help

Sharon
 
You can use a variable in a record selection, but it will prevent the SQL from being passed to the database.

The post is too nebulous to allow for helping you, perhaps you might post intent with specifics.

The best way to handle Holidays, Weekends and Weekdays is to create a table which contains all dates, with attributes for each date stating things like that, and more. This is standard fare in Data Warehousing and gets you around the hacks.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top