Salary
Feb 23, 2006
Hello,
For the last few months I've been developing a database in access for the company where i work.
The database stores all kinds of waranty cards, and marketing campaign information about customers.
It is currently still in beta phase(it is being improved all the time) but it is fully functional, having an advanced search engine, multiple GUI's for all kinds of user information to be typed in and an advanced statistics engine.
It is currently being used by around 4-5 persons, and I am the only one working on its development.
My question is, around how much money should I get paid a month ? I must specify that i get paid the minimum salary. I know that it depends upon the country which I am in ( I live in a country in Scandinavia), but still I would like to hear some opinions from pro's or non-pro's who get paid to develop Access databases.
View Replies
Jun 10, 2006
Hi
I am creating an employee payroll tracking database and having trouble with creating a query salary by month, salary by qtr, and salary by yr
I have 2 tables: Employee (first name, last name, position, start date) and Salary table (salary, bonus, total)
What is the code to get salary by month for each employee, also seperate qury for salary by quarter, and then salary ytd.
Please help!
Thanks so much!
View 2 Replies
View Related
Jun 3, 2005
I'm trying to produce a query that will bring up a list of all employees with their current salary amount. The table however, has all changes for an employee and reads as follows:
Table Name(NBRJOBS)
Employee ID-- Date of Change -- Salary Amt
1234 ----- 01/01/2003 -------- 500.00
1234 ----- 05/01/2003 ----- --- 600.00
1234 ----- 11/01/2003 ---- --- 700.00
2222 ----- 03/05/2004 ------- 200.00
2222 ----- 12/05/2004 ---- --- 300.00
2222 ----- 02/01/2005 ---- --- 300.00
It will be necessary to create a report to list out all employees and their current salaries. Any suggestions?
View 5 Replies
View Related
Jun 17, 2006
Hi,
I am trying to create a query that calculates Bonus Prorate and Salary Prorate. In my query I had the following fields: Employee Id, Name, start date, Salary, Bonus, Disc Bonus, Guaranteed Bonus, Total Bonus.
The formula I was told to use to get the Salary prorated value is:
start date/365 x salary. How can I incorporate this in Access query?
Thanks a lot! :)
View 3 Replies
View Related
May 6, 2012
How to find out the Salary. A school remains closed for Winter vacation from 15th Dec. of Current year to 28-29 Feb next year.)
The management disburse the salary to the school as per following procedure
If the Employee has not completed 6 months period (180 days) as on 15th December of current year he will not be entitled to winter salary (2 and a half months) from 16th Dec. of current year to Last day of Feb. next year. For rest of the period he will get normal salary. i.e. for 11 days of June and July, August, Sept. Oct, Nov and 15 days of Dec. of current year he will get full salary.
To elaborate it further it means that if an employee has been appointed on 19th June of the current year his winter salary with effect from 16th Dec. of current year to last day of Feb next Year will not be disbursed. For other time period he is entitled for normal salary.
View 6 Replies
View Related
Sep 6, 2012
I have one table with employees and positions. Each position has a specific rate which is stored in another table (table2). Since the rates of the positions are changing, I want each time the employee get paid with the correct rate.
The problem is that I do not want to lose historic data since I want the rate to calculate the salary. I thought that the best way is to look up for the rate according to the position and the period that is valid.
I have attached herewith a small example with the two table that I want to use the relationship.
View 3 Replies
View Related
