Bayt.com

Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How do I write a formula on microsoft Access to calculate the salary for more than one period ?

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 

SQL Microsoft Access
user-image
Question ajoutée par Eslam mohammad mahmoud El Hendawy , Payroll Specialist , Hemaya Security Services L.L.C.
Date de publication: 2017/03/03
Apprécier (0) Vues (20) Suiveurs (3) Réponses (2) Report Question
Ajoutez Une Réponse
Inscrivez-vous ou connectez-vous pour répondre.
MOHAMED MAHMOUD EISSA
par MOHAMED MAHMOUD EISSA , Software department MGR. and Senior developer , Global Media Services GMS

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");

Ziauddin Zia
par Ziauddin Zia , Software Engineer , Asia Poultry Feeds (Pvt) Ltd

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/

Ecrivez Votre Réponse
More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?

Obtenir de l'aide