Yes Bob,
This is what i was looking, @ % of each division from the main table.
Will it be to help me out.
The Main table has the following feilds.
Salary, HRA, Food Allowance, OverTime, Bonus, Incentives.
to be Allocated.
If you can provide me the mail id i shall send the sample for understand better.
Thanks
Shekar
--- In MS_Access_Professionals@yahoogroups.com, "Bob" wrote:
>
> I give this some thought as I was walking the dog.
>
> 1 - you can use the current table and produce two queries using the logic previously mentions then UNION ALL both queries for your combined report.
>
> 2 - the current file structure limits your options. Would there ever be a need to have someone work for 3 or more division? If that may be the case then a separate division table may be of help with the following columns:
>
> ID
> Division
> Salary_Split
>
> Now you could have me work for all divisions with specified allocations.
>
> ID DIVISION SALARY_ALLOCATION
> 10 MLPA 50%
> 10 MLQT 20%
> 10 ML?? 20%
> 10 ML?? 10%
>
> We will then join the table with the HR table and produce the necessary detail report with the respective salary breakdown.
>
> Do you need to see the actual code? If so I could provide that later today when I have more time.
>
> Bob
>
> --- In MS_Access_Professionals@yahoogroups.com, "Bob" wrote:
> >
> > 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 (6) |
Tidak ada komentar:
Posting Komentar