මගේ කොම්පියුටර් ප්රෝග්රම් එකක් තියෙනව access වලින් කරන්න ඒකට් Ms accessදන්න අයියල පොඩ්ඩක් උදව් කරන්න පුලුවන්ද
im praparing taxpayer,tax payable,tax paid database ekak
taxpayer table
fields
taxpayer no
taxpayer name
taxpayer address
tax return table
taxpayer no
tax type
tax period
tax payable
tax period table
Fields
Quarter (1st quarter,2nd quarter,3rd quarter,4th quarter)
Quarter code(2016-1,2016-2,2016-3,2016-4)
payment table
taxpayer no
taxpayer name
tax period
tax paid
payment period code for 1st quarter 2016-11,2016-12,2016-13
quarter ekakaka payment masa 3kin gewanne
1.Querry eken all quarters walata pay karapu tax tax period wise total ganna oney
2.querry eken taxpayable in Retun table walin payment aduwela..default payable gana ganna oney
default=taxpayable-tax paid
taxpayable eka 3moths walin gewanne,,,ethin kohomada eka payable quarter eke tax eka 3months payment ekathuwen adukaranne
example
1st quarter default=1st quarter payable - (january payment+feb payment+march payment)
example: 2016 1st quarter eke Tax return eke payable tax eka match karanna oney 2016 jan feb mar total ekka
payable2016-1 vs payment("2016-11"+"2016-12"+"2016-13")
meyka ganna queery eke danne kohomada
*taxpayerge no eka taxpayable form eke enter karanakotama taxpayerge name eka auto yata text box ekata enna hadanne kohomada...foreign key dalada?
thankyou
Last edited:
Tax. NO!!!!
