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 (5) |
Tidak ada komentar:
Posting Komentar