Query

D

desai.rohit27

Hi. i have one table which contains employee name, date of joining,
payment date and salary for the month. the employee name and date of
joining together form the primary key. i need to create a query which
will filter each employee and perform the necessary calculations on
the salaries of that employee. please note that this has to be done
automatically for all employees. can this be done?
 
D

Douglas J. Steele

Sorry, but you'll have to provide more details.

Filter the employees how? Perform what calculations?
 
R

rkc

Hi. i have one table which contains employee name, date of joining,
payment date and salary for the month. the employee name and date of
joining together form the primary key. i need to create a query which
will filter each employee and perform the necessary calculations on
the salaries of that employee. please note that this has to be done
automatically for all employees. can this be done?

You should consider asking for help with the design of your database.
As it is now you can only have one record per employee unless
employees
join multiple times so there really is no need for calculating
anything.

Getting data out is much easier when you have thought about what has
to go in and where to put it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top