fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thank you for your time.

Ex. txtgrossfortax = 6000

check employee master table for employee BIR status. If BIR Status = ME2
6000 should get the or lookup value of Fields in the tblWTAX.

The lookup or select command (which i don't know honestly what to use)
should get the value of Field5 in the tblWTAX which is 5600 & % of .30

then

compute value of txtgrossfortax less value of Field5

6000 - 4917 =

400 * 30% = 120 (20% is constant based on tblWTAX Field5) (see tblWTAX)

120 + 104.17 = 570.77 (104.17 is constant based on tblWTAX Field5) (see
tblWTAX)

224.17 should be the tax that will go to the txtWTAX


Table tblWTAX is like this:

BirStatus Field1 Field2 Field3 Field4 Field5 Field6 Field7
% .5 .10 .20 .25 .30 .40 .50
constant 50.00 70.00 90.00 110.00 104.17 150.50 175.98
S 100 1500 2700 3400 5600 7833 9000
ME2 100 2300 3500 4000 5600 7823 15000

Table employee master like this:
EmpIDno (Index)
BIRStatus (Relation with tblWTAX)

PLease help me with the syntax or code

Thank you very much.

Lance Arnold
 
Back
Top