Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
ihave data base contain from table
employee table
  empno
  ename
  val_sal
 
adittion work
  empno
  adwork
 
comm
  empno
  comm
 
bunish
   empno
   bun_val
 
salary
  empno
  sal
iwant while add value off(+adwork,+comm,-bun_val,+sal)in my data base the val_sal
contain (+adwork,+comm,-bun_val,+sal) in salary of employee automatical iuse access data base how iwork that
i can't use one table becuse iuse different user
thank
Posted 24-Nov-12 2:36am
Edited 24-Nov-12 4:13am
Nelek63.3K
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Your question is confusing and not very well explained, however, assuming that what you want is this:
1) To record the basic (normal) salary for an employee
2) Record extra income for additional work
3) Record expenses to be removed from total salary (bunish?)
4) Record extra income for 'comm' work, (whatever that is, commission?)
 
Then you would be better of having a table for employees and a single table for income items. Each income item would have a category (from a third table), 'addition_work', 'bunish', 'comm', 'salary' etc.
Your total income would then be a query not a table using SUM(field from income items table) and using Group By for various reporting effects.
A period (e.g. month, week) etc. would seem sensible also.
 
Then have a look at this[^].
 
M
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 George Jonsson 215
1 Kornfeld Eliyahu Peter 169
2 OriginalGriff 120
3 PIEBALDconsult 110
4 BillWoodruff 85
0 OriginalGriff 6,165
1 DamithSL 4,658
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,649
4 Sergey Alexandrovich Kryukov 3,294


Advertise | Privacy | Mobile
Web01 | 2.8.141220.1 | Last Updated 25 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100