Search results

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

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 -----...