[MS_AccessPros] Allocating of Data

 

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 (1)

Recent Activity:

• New Members 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___