Shekar
Assuming that you will have two reports (one for Division1 and one for Division2) - you could set up a Division_Salary column in each of the reports. For example: the Division1 report will contain a hidden column for Division2 and the Division_Salary column will perform a check that my look like this:
IIF(ISNULL(Division2),Salary,(Salary*(-1)))
You would simply reverse the roles for the Division2 report.
Does this help?
Bob
--- In MS_Access_Professionals@yahoogroups.com, "tchshekar" wrote:
>
> Hi
>
> I Have a table Containing:
> ID
> Person
> ECOde
> Division1 [MLPA or MLPT]
> Division2 [MLQA or MLQT]
> Salary
> TravAllo
> MedAllo
> HRA
>
> Kindly Note:
> Allocation is between Division 1 & Division 2 the Details of Salary to HRA.
>
> Some Persons have only Division.
>
> Some Persons have Both Divisions Filled.
>
>
> I Need the result in query / report where the Salary to HRA are split based on Divisions.
>
> If Both Divisions are there, then Salary - HRA will be 50% allocated to Each.
>
> Kindly Help.
>
> Thanks
>
>
> Shekar
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar