Search results

If someone arrives at 9:15 and leaves at 5:45, 15 minutes will be deducted from duty hours. nothing will happen around lunchtime.

I am working on the attendance table to get Overtime and Duty hours. Conditions: Duty hours are 9:00:00 AM to 6:00:00 PM & Grace Time is 15 Minutes (If an employee arrives after 9:15, the number of minutes he is late will be deducted from his 9 hours duty hours). Overtime will be started after...

I Could not found CDec() in expression builder in Query.

Thank you so much solved.

Thank you so much dear! Now I am using it in a Query & its working. But there is a problem. Actually I want to combine some numerical values from 3 fields and concatenate them to make a numerical field. But its result type is not number. So I can not sort it as (Smallest to Largest). I have the...

Thank you isla, but nn error occurred.

Hi, I have an excel formula to get the first word from a sentence. =LEFT(CellName,FIND(" ",CellName)-1) Example: I want to use this in Microsoft Access to find the first word from a particular field by using calculation column. Can anyone guide me how to use this? Thank you

I really like your advice. I agree with you. And my managers know that I am a beginner and that is part of my learning. That is why they are not stopping manual accounting. Rather, they will run the manual accounting side by side until they are satisfied with the database I have created. They...

Yes CJ exactly my manager needs simple database like this.

Sir, I am creating a very simple database. Which will be checked first and then used. And I got this task from my manager.

I want to tell you that my boss gave me the task of creating this accounting database because our company is currently running manual accounting. And people here are not very familiar with computerized accounting. I am currently a beginner in the field of accounts. And I love to work Microsoft...

Gasman, Dear Now I am learning to grow!

Hi, I've created a voucher form to make different vouchers. There is a lookup field to select the Type of Voucher. List of Voucher Types is: CP-Cash Payment CR-Cash Receipt BP-Bank Payment BR-Bank Receipt PB-Party Bill JO-Journal SL-Sales A subform named GeneralLedger is associated with this...

Thank you all very much for your valuable advice.

Thank you so much George

I'm sorry if I said something wrong.

Oh, maybe I didn't understand what he was saying.

Hi, I am beginner in not very expert in Ms Access but I am learning. I got a project from the company I work for. The Project is to create an accounting database. Database should be included: General Ledger Chart of Account Different types of vouchers (including voucher printing functionality)...

Thank you Pat Hartman for your response.

Thank you so much dear