Search results

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.

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

Thanks for the Help its Working now.

I am trying to Write it in the WorkDays Field Control Source but its not showing anything.Or should i write it in any Event. As i Already have the calcualtion in the EarnedSalary and GrossPay fileds control Source i amwriting it in the WorkFields. I am very sorry to disturb u with many...

its not in a Query it should be displayed on the Form.

I have GrossPay field on the Form and calaculating it as GrossPay=[Earned Salary]+[Earned SPL]+[HRA]+[Transport]+[OT] from the control source I am getting EarnedSalary from the calcualtion of EarnedSalary=BasicPay/TotalWorkingDays*ActualWorkingDays. When ActualWorkingDays is 0 then...

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

@ ALex I have clicked on the create a form and automatically all the fields in the table have been populated.

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