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
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...
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...
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.
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)...
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...