wildrancher
Programmer
Hello all,
This is what I have:
Table T1 has the following fields:
Emplid
Period
Salary
The information is stored as:
Emplid Period Salary
100 DEC2002 123
101 DEC2002 456
100 JAN2003 456
101 JAN2003 789
Now this is what I want to do.
I want to create a report which will help me do the following.
I want to know what is the salary I paid to the guy in the current Period and prior prior period.
For Employee 100 the view should bring out the following result set
Empl CurrentPay Previous Pay
100 456 123
The period will be a Prompt that the users will provide at run time.
Now when the prompt is for JAN2003 then prior period should be DEC2002. How can I make it work.
Please Help.
Thanks
wildRancher
This is what I have:
Table T1 has the following fields:
Emplid
Period
Salary
The information is stored as:
Emplid Period Salary
100 DEC2002 123
101 DEC2002 456
100 JAN2003 456
101 JAN2003 789
Now this is what I want to do.
I want to create a report which will help me do the following.
I want to know what is the salary I paid to the guy in the current Period and prior prior period.
For Employee 100 the view should bring out the following result set
Empl CurrentPay Previous Pay
100 456 123
The period will be a Prompt that the users will provide at run time.
Now when the prompt is for JAN2003 then prior period should be DEC2002. How can I make it work.
Please Help.
Thanks
wildRancher