SOLVED: Using conditional statements

[FirstStruck]

Hello,

I am trying to write a report that will display when an employee is given a pay raise.
I have 4 Fields: Name, Pay Date, Job, Pay Rate

There are 10 possible Jobs 1 employee could perform during 1 Pay Date. Each of those 10 jobs could possibly be at a different Pay Rate.

Here is an example of 1 employee's output:

Name                 Pay Date                Job                 Pay Rate
John Doe            1/1/12                     Server            $4
John Doe            1/1/12                     Host               $5
John Doe            1/1/12                     Cook              $10
John Doe            1/8/12                     Server            $4
John Doe            1/8/12                     Host               $5
John Doe            1/8/12                     Cook              $11

Notice how the Pay Rate changed for Cook from $10 to $11. How can I use conditional statements to say display the raise in Cook from $10 to $11, but don't display the Server & Host because they didn't change - And don't display folks who didn't get a raise?

Thanks for your help or suggestions!!

[navissar]

I'd try something along the lines of a filter on maximum([pay rate] for [job],[name])<>minimum([pay rate] for [job],[name]).

[FirstStruck]

I'd try something along the lines of a filter on maximum([pay rate] for [job],[name])<>minimum([pay rate] for [job],[name]).

This worked perfectly. Thanks so much!