Search results

  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
  13. K

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

    Hi Arnel I solved this problem but another problem came up with it. I have calculated the running balance with the help of a subquery, and it also appears in the report. But now when I am trying to get its sum in the report I am getting an error. Please guide me about it.
  14. K

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

    Dear Arnel thank you for your response. The error is appearing: Also the Cash Received and Paid etc are just an example of narrations. Narration can be contained in the whole sentence.
  15. K

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

    Hi, I need help calculating a running balance in a report field. Where the debit will accumulate in the balance and the credit will be subtracted from it. In the image below my report is getting the "CASH IN HAND" transactions from General Journal and showing the balance from there. I also...
  16. K

    Solved I need help in DLookup

    Its working perfectly. Thank you so much arnel.
  17. K

    Solved I need help in DLookup

    I wanted that when the user writes the name of the account and selects its subcategory, its main category and a unique code to be automatically generated.
Top Bottom