Recent content by Khurramshaikh47

  1. K

    How to allow 3 decimals in the table, query, and form.

    Hi, I have a number field in my table. I want to display 3 decimals like 3569.150 but when I type "3569.150" access automatically converts it to "3569.000". How can I allow it to show the numbers after decimal points? Waiting for the expert's guidance, Thank you
  2. K

    Solved I need help converting overtime hours to the round figure.

    Ahh, It's a mistake in my example sheet.
  3. K

    Solved I need help converting overtime hours to the round figure.

    Actually, the rule for the first 1 hour is different. A full hour of work is required to earn the first hour of overtime.
  4. K

    Solved I need help converting overtime hours to the round figure.

    Hi, I have an attendance table. There are some fields: 1) Time_In 2) Time_Out 3) Overtime The field overtime calculates the overtime hours after completing 9 working hours. I need to restrict the overtime hours value: If the Overtime hour is less than 1.00 then convert it to 0.00. After the...
  5. K

    I need help adding some transactions to the vendor ledger.

    Thank you for your response jdraw, Yes sure, Lookup VName from ChartOfAccount Table in Voucher Table. Voucher Table General Ledger Table:
  6. K

    I need help adding some transactions to the vendor ledger.

    I have looked up a filed VName from ChartOfAccount table to voucher and then used the VBA the following code: Private Sub VName_AfterUpdate() DoCmd.RunSQL ("update GeneralLedger set VName= '" & Me.VName & "' where VoucherNo like '" & Me.VoucherNo & "'") End Sub to post its value (Title of...
  7. K

    I need help adding some transactions to the vendor ledger.

    Actually, I can only use debit and credit fields separately as this is the requirement of my project.
  8. K

    I need help adding some transactions to the vendor ledger.

    Thank you so much plog. I apologize for the late reply. I tried rebuilding the entire database where I let the Narration and VoucherDate remain in the voucher table while trying to link to the voucher number. I failed because my voucher number field is a calculated field.
  9. K

    I need help adding some transactions to the vendor ledger.

    These are the tables and queries I use Voucher Table and GeneralLedger Table for the entry of debit credit transactions. Let me show you both tables: 1) Voucher Table: 2) General Ledger Table: GeneralLedger Table also has more columns, I have hidden them to show the necessary columns. 3)...
  10. K

    I need help adding some transactions to the vendor ledger.

    I have a voucher form with the help of which I do voucher entries. Each entry is posted in a table called GeneralLedger. I then display the entries for specific heads of accounts from this table in a separate report, such as all transactions for a specific vendor. Let me share some images to...
  11. K

    Solved I need running balance including add and less in the report field

    Thank you so much arnel. Its solved.
  12. K

    Solved I need running balance including add and less in the report field

    Report: AccountLedgerReport AccountLedger Use the following Dates and Account Name: to check
Top Bottom