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 wOOdy-Soft 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: Atrzy
- Content: Threads
- Order by date
-
CASE with multiple criteria
Is it possible to write a CASE statement using AND? Here's an example of what I'm trying to do: If Location = 0001E and Jobcode = 900922 Then return Director If Location = 0001 and Jobcode = 900922 The return Allocator Else NA I don't know how to properly write the CASE statement. I'm on...- Atrzy
- Thread
- Replies: 2
- Forum: Strategic Reporting Systems(SRS): ReportSmith
-
Use Derived Field to group a range of Comprates together?
My report lists employees by name, job, comprate, etc. I want to group together all persons who earn between a certain rate of pay (comprate). For example, Group A would be between $7.00 and $9.00, Group B between $9.01 and $11.00, and so on (up to as many as 7 groups). Can I do this with a...- Atrzy
- Thread
- Replies: 3
- Forum: Strategic Reporting Systems(SRS): ReportSmith
