Search results

Query Multiplication Sorry I confused everyone. :) I'm retrieving more then just that one field. Also, Total_pay, but based on the earn_code of OT1. I think Pat answered my question. Thank you everyone.

Query using If and Multiplication Hi Pat I just want to multiply OT1 *.5 if earn_code is = OT1. Ignore all other codes in earn_code

IF statment and Mutiplication Hi Ken It's in a Query. THANK YOU!

Hi I need help creating a calculated field. I'm not sure how to write the IF statement. Calculated Field Name: Special_Rate Data Field Name: phrearn_earn_code Bascially.... If phrearn_earn_code = OT1, then I need to Multiply OT1 * .5 for a total. Thanks

max salary Thanks Pbaldy. I worked it out. I really appreciate your help.

Max Salary Thanks for the help. I appreciate it. That gets me the max salary date. When I add the salary field in though, it brings up multiple dates again and multiple salaries; Very confusing to me. SELECT Employee ID, Max(EFFECTIVE_DATE) AS MaxDate, SALARY FROM TABLE GROUP BY Employee ID;

Max date Paul Thanks for responding. The problem I'm having is with the max date. It brings up the most current date in the file, but the most current date can be different for each employee, so I only get one employee when I do the max date. It brings up the one employee with the most...

I'm trying to produce a query that will bring up a list of all employees with their current salary amount. The table however, has all changes for an employee and reads as follows: Table Name(NBRJOBS) Employee ID-- Date of Change -- Salary Amt 1234 -----...