Recent content by Ganie

Hello, I found this file with other thread but only limited up to 10 weeks (im getting this error)is anyone can help me to extend the weeks up to 24 weeks. Thank's in advance.

PLease check my excel table maybe you can help me. or maybe someone is selling with the same. Thanks

Ongoing Balance 35830 Cash on Hand 10 S# CustomerID Name Investor Program Credit Amount+Interest Date Start Due Date Month Duration Principal Interest Savings Weekly Pay Status 1 80001 Customer 1 Investor 1 1 Week 1060 4-Jul-23 11-Jul-23 Jul.23 1 Weeks 1000 60 1060 Pending 2...

Hello Thank you, But how can i execute this in access newbie here. my excel table is like this.

Hello is anyone can help me to create daily weekly and monthly loan schedule in ms access. im using excel sheet manually. is anyone can help to develop in ms access automatically. Like Daily payment schedule Weekly Payment Monthly Payment Thank's. in advance.

Hi, Sorry for that. i understand. take care and God bless. again sorry and thank you for your time. maybe i will stay with the excel seems the access is to complicated.

Sorry if i confused you. You have added random dates to the Holidays table?? Why did you do this? the dates i have put in the Holidays table is all Fridays im just trying if will work. and i see that is working friday were excluded in the calculation please check and correct me if im wrong...

Hi Mike, The scenario should be like this. If employee take a leave on July as shown in the Last annual leave Info which is 21 days only because there is 5 days holiday on that month. 21 days will be deducted to leave balance. so his leave balance will become 11.219 on august 01 2021...

and allso the unpaid leave history should add the total

Hi Mike, yeah we are almost there only things i forgot to mentioned you. 1. Unpaid leave should include all in calculation example 12.07.2021-16.07.2021 = (5 days including Fridays and Holidays if any) 2. need to add another field for leave balance here is the formula in excel Leave...

Hi Mike, Employee Length of service as of 01 Mar 10 is 206 Days. Here my Formula with excel Leave Start (01 Mar 2010) -Joining date (08.08.2009)+1 - Unpaid Leave (If any) and the leave entitlement would be 16.9 Days. Here is the formula for getting leave entitlement Length of Service (206...

hi mike, Thank's for the guidance and correction. How about leave entitlement? sorry to ask you a lot of question. since i have no idea to store formulas in access. When you say Unpaid Leave is this the total days of Unpaid ? (Yeah total unpaid leave)

Hi isladogs, Thank's. for your suggestion. hoping that you can help me too. signing up.

Hi mike, How you doin, i have checked and included Fridays in Holidays table and remove Saturdays and Sundays in the module. i think is we are in a right track now. but i don't want duplicate. if the record is already there it should say duplicate entry is not allowed. and also if the...

Hi, mike Really appreciate your effort to help me. It is possible to add all fridays in the holidays table (assuming that they are also holidays) so they will not included in the count of days? Then saturday and sunday will include in the count of days. What do you think? Thanks and God bless.