Register now or log in to join your professional community.
how do I write a formula on microsoft Access to calculate the salary for more than one period ?
for Example if an Employee joined the company on theth of June so if I want to calculate the accrued salary from this day till-1- which is days, just for the record I know how to calculate it manually and on excel but I want to automate it in an Access Database.
thank you in advance
There are many ways to do this task The main idea is to group the data by the required period
This is a simple query example that should put you on the right track:
SELECT Format([TransDate],"mmmm") + " " + Format([TransDate],"yyyy") AS [SalDate], Sum(Receivable)-sum(Deduction) AS net
FROM Sal
GROUP BY Format([TransDate],"mmmm")+" "+Format([TransDate],"yyyy");
Hi, I am not using Microsoft Access.
But i think you should use "group by" query in access.
This link will help you regarding calculating on group:
http://www.gcflearnfree.org/access2007/using-queries-to-make-data-meaningful-part-2/3/
Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.