Query

  • Thread starter Thread starter desai.rohit27
  • Start date Start date
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?
 
Sorry, but you'll have to provide more details.

Filter the employees how? Perform what calculations?
 
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?
Click to expand...

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