Search results

  1. A

    calculated field in a query

    I Have some calculated fields in a query and want to update it in the table .So,is there anyway to store these fields.Otherwise can i store this Query data every month in database so that when i re-run the query the previous month data will not be affected. can anybody help me out.
  2. A

    Export report to excel

    How i can export the Data of Report to Excel in Access 2007. Is it possible to export because the export option for Excel is disbaled. How can i do this. Can anybody help me please...
  3. A

    IIF statement in Form of Access 2007

    Hello I have created a form with the fields of the table and i am calculating the EarnedSalary and EarnedAllowance based on the workingDays.Its working fine if i enter workingDays any value. Now my Question is If an employee is not present for the whole month then Working Days=0 and the final...
  4. A

    Inserting Data in table

    Hi Every body i am new to Access and i am designing a payroll system for my company. I have created a Table with EMP Id,Name,Basic Pay,Total Working Days,Actual Work Days,Earned Salary,OT days,OT Hrs,OT Pay......... Now i have created a form with all the above fields.and calculated the earned...
Back
Top Bottom