Search
Search titles only
By:
Search titles only
By:
Log in
Register
Search
Search titles only
By:
Search titles only
By:
Menu
Install the app
Install
Forums
New posts
All threads
Latest threads
New posts
Trending threads
Trending
Search forums
What's new
New posts
New ads
New profile posts
Latest activity
Free Ads
Latest reviews
Search ads
Members
Current visitors
New profile posts
Search profile posts
Contact us
Latest ads
Ad icon
port.lk Domain for sale
Lankan-Tech
Updated:
Today at 3:55 PM
Colombo
Kaduwela - Two Storey House for Sale
dilrasan
Updated:
Thursday at 2:23 PM
Ad icon
Wechat qr verification
Pawan2005
Updated:
Thursday at 1:28 AM
🚀 GOOGLE AI PRO 18 MONTHS ACTIVATION 🚀
sayuru bandara
Updated:
Wednesday at 5:34 PM
Pure VPN - Up to 27 Months
vgp
Updated:
Jun 5, 2026
Electronics
Vehicles
Property
Search
Reply to thread
Forums
General
ElaKiri Talk!
MS Access help pls
Get the App
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="Nilushi_Nugegoda" data-source="post: 21016412" data-attributes="member: 371278"><p><strong><span style="color: Blue"><span style="font-size: 15px"></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">මගේ කොම්පියුටර් ප්රෝග්රම් එකක් තියෙනව access වලින් කරන්න ඒකට් Ms accessදන්න අයියල පොඩ්ඩක් උදව් කරන්න පුලුවන්ද</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">im praparing taxpayer,tax payable,tax paid database ekak</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"><u><strong>taxpayer table</strong></u></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">fields</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">taxpayer no</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">taxpayer name</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">taxpayer address</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"><strong><u>tax return table</u></strong></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">taxpayer no</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">tax type</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">tax period</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">tax payable</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"><strong><u>tax period table</u></strong></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"><strong><u></u></strong>Fields</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">Quarter (1st quarter,2nd quarter,3rd quarter,4th quarter)</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">Quarter code(2016-1,2016-2,2016-3,2016-4)</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"><u>payment table</u></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">taxpayer no</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">taxpayer name</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">tax period</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">tax paid</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">payment period code for 1st quarter 2016-11,2016-12,2016-13</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">quarter ekakaka payment masa 3kin gewanne</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">1.Querry eken all quarters walata pay karapu tax tax period wise total ganna oney</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">2.querry eken taxpayable in Retun table walin payment aduwela..default payable gana ganna oney</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">default=taxpayable-tax paid</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">taxpayable eka 3moths walin gewanne,,,ethin kohomada eka payable quarter eke tax eka 3months payment ekathuwen adukaranne</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">example</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">1st quarter default=1st quarter payable - (january payment+feb payment+march payment)</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">example: 2016 1st quarter eke Tax return eke payable tax eka match karanna oney 2016 jan feb mar total ekka</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">payable2016-1 vs payment("2016-11"+"2016-12"+"2016-13")</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">meyka ganna queery eke danne kohomada</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">*taxpayerge no eka taxpayable form eke enter karanakotama taxpayerge name eka auto yata text box ekata enna hadanne kohomada...foreign key dalada?</span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px"></span></span></strong></p><p><strong><span style="color: Blue"><span style="font-size: 15px">thankyou</span></span></strong></p></blockquote><p></p>
[QUOTE="Nilushi_Nugegoda, post: 21016412, member: 371278"] [B][COLOR="Blue"][SIZE="4"] මගේ කොම්පියුටර් ප්රෝග්රම් එකක් තියෙනව access වලින් කරන්න ඒකට් Ms accessදන්න අයියල පොඩ්ඩක් උදව් කරන්න පුලුවන්ද im praparing taxpayer,tax payable,tax paid database ekak [U][B]taxpayer table[/B][/U] fields taxpayer no taxpayer name taxpayer address [B][U]tax return table[/U][/B] taxpayer no tax type tax period tax payable [B][U]tax period table [/U][/B]Fields Quarter (1st quarter,2nd quarter,3rd quarter,4th quarter) Quarter code(2016-1,2016-2,2016-3,2016-4) [U]payment table[/U] 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[/SIZE][/COLOR][/B] [/QUOTE]
Insert quotes…
Verification
Hata thunen beduwama keeyada? (60 bedeema thuna)
Post reply
Top
Bottom