One report and the query will be doing the salary split between divisions (if necessary). For example: I am an employee who works for both division MLPA and division MLQT. My salary is $100,000 so the query will split that value allocating $50,000 to each of my departments.
You have indicated that the HR table will contain two division columns (Division1 and Division2). In the event that both of these columns both have a value then the query will generate two output rows for each of the respective divisions:
ID Person Division Salary HRA Etc...
-- ------ -------- ------ --- ------
10 Bob MLPA $50,000 ??? ...
10 Bob MLQT $50,000 ??? ...
This is what you need to happen - correct?
Bob
--- In MS_Access_Professionals@yahoogroups.com, "tchshekar" wrote:
>
>
> 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 (4) |
Tidak ada komentar:
Posting Komentar