Hi Bob,
The repot required is in one.
Similary to below : Summary
Division : Salary : HRA : ETC
MLPA : Salary : HRA : Etc
MLPT : Salary : HRA : Etc
MLQT : Salary : HRA : Etc
MLQA : Salary : HRA : Etc
Thanks,
Shekar
--- In MS_Access_Professionals@yahoogroups.com, "Bob" wrote:
>
> 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 may look like this:
>
> IIF(ISNULL(Division2),Salary,(Salary*(.5)))
>
> 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 (3) |
Tidak ada komentar:
Posting Komentar