Search results

  1. K

    How can i generate monthly payment in query as per below calculation

    I got loan of a 5,000 with monthly interest of 6%. I will pay it for 3 months in a semi monthly basis, thus my monthly installment is 983.33 I did not use PMT in computation, simply just [5000 x 0.06 x 3] + 5000 / 6 I try to apply in the attached sample but i failed to do. thank you.
  2. K

    Ms Access: What is the best way to extract Appropriation as per distribution

    thank you sir for the response.
  3. K

    Ms Access: What is the best way to extract Appropriation as per distribution

    What is the best way to extract appropriation as per percentage distribution. 1. Distribution Percentage can be changeable 2. Particulars/Services can be change or have an additional - example i need to add Represenstation Expenses 5% 3. Maximum 100% Total...
  4. K

    How to add bulk Item from combobox items into continues form instead of selecting one by one

    I place this transaction in subform Link Master Fields: IDD Link Child Fields : IDD
  5. K

    How to add bulk Item from combobox items into continues form instead of selecting one by one

    Thank you so much sir. I will try this sir.
  6. K

    How to add bulk Item from combobox items into continues form instead of selecting one by one

    That;s That makes sense sir.
  7. K

    How to add bulk Item from combobox items into continues form instead of selecting one by one

    I have i combox which row source : SELECT tblMpf.MpfID, tblMpf.Particulars FROM tblMpf ORDER BY tblMpf.MpfID; - Is it possible that when i select one item the following all items in the list will add to the record automatically ( 1 - 20 ) Thank you so in advance for the support. Kamayo Ako
  8. K

    Solved How do I put a page header on every page except the first?

    Maraming salamat sir ng sobra
  9. K

    Solved How do I put a page header on every page except the first?

    I've got it. thank you... I use below code Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer) If Me.Page > 1 Then Me.PageHeaderSection.Visible = True Else Me.PageHeaderSection.Visible = False End If End Sub
  10. K

    Solved How do I put a page header on every page except the first?

    I have a report with report header and page header. On this case i want to display only page header starting on Page 2 and so on. Thank you so much in advance Kamayo Ako
  11. K

    Solved How extract the remaining years, months and days before compulsory retirement date

    Salamat sir.. nakuha ko na... ito ginamit sa sa query: DateAdd("yyyy",56,[BirthDate])
  12. K

    Solved How extract the remaining years, months and days before compulsory retirement date

    Sir may may additional na concern ako. Duon sa pag calculate ng Compulsory Retirement date. yung Exact Retirement Date after 56 years old. Halimbawa birthdate ko is : 06 Jun 1990 + 56 = 06 June 2046 is my Compulsory Retirement Date ang lumabas kasi sa akin sir is 23 May 2046 calculated...
  13. K

    Solved How extract the remaining years, months and days before compulsory retirement date

    Maraming salamant nang sobra sir.
  14. K

    Solved How extract the remaining years, months and days before compulsory retirement date

    Maraming salamat sir....
  15. K

    Solved How extract the remaining years, months and days before compulsory retirement date

    I just reverse the CalcAge Functions and i use ABS function to avoid negative result Public Function CalcRetirement(dteCRD As Date, Optional dteEnd As Date) As String 'years, months & days Dim intyears As Integer, intmonths As Integer, intdays As Integer 'If no end date...
  16. K

    Solved How extract the remaining years, months and days before compulsory retirement date

    still get stuck
  17. K

    Solved How extract the remaining years, months and days before compulsory retirement date

    I will do that. Thank you....
  18. K

    Solved How extract the remaining years, months and days before compulsory retirement date

    Have a goodday to all!!! I just want to ask your assistance again on how to extract the remaining years, months and days before compulsory retirement date. Attached the sample database for the concern transaction. Thank you so much in advance.....
  19. K

    MS ACCESS: How to extract quantity consumption quarterly according to transactionDate by section

    Yes sir. I will do this sir . Thank you so much
  20. K

    MS ACCESS: How to extract quantity consumption quarterly according to transactionDate by section

    tblInventory - Filtered by section ADMINISTRATIVE SECTION Trans Date ItemID Description...
Back
Top Bottom