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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Meloncolly
- Order by date
-
Perform lookup type of operation in formula
Thanks all for the replies - maybe I didn't explain my final goal correctly, but I need to know the TeamID, not dateChanged. synapsevampire, thanks for your reply to my other post, by the way.- Meloncolly
- Post #4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Perform lookup type of operation in formula
I'm trying to perform a lookup type of operation on a table. The table is tblEmpHistory. Two fields i'm interested in: DateChange, TeamID. The DateChange field records the date an employee changed team, and TeamID records the NEW team ID at that date. Using a parameter date field, can someone...- Meloncolly
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Daily parameter report to monthly
Hi folks, I have set up a parameter report to query our employees table. Based on tblEmp.DateHired and tblEmp.DateDeparted I can count the number of people ppresent on a given date and the number leaving on the same date, by using a parameter field called ReportDate. So, my result is...- Meloncolly
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
