Calculate Payroll In Order Database
Mar 22, 2007
I have an order database Access 2000 for an inspection company, tblInspectors, tblOrders, tblCustomers, I want to be able to calculate inspector pay within order database. Each inspector is an independent contractor, so it just needs to calculate percentage, for each inspection performed and total for pay period. Each inspector is paid a different percentage, which is stored in tblInspectors. Payroll is paid every two weeks . . . I've been trying to figure out the best way to do this ... :confused: Any advise be greatly appreciated.:confused:
View Replies
ADVERTISEMENT
Aug 22, 2006
Hi,
I would like to get your advice on my table setup and relationships for this payroll project. The company is an engineering company with Projects (or construction sites) around the world.
The 'Candidates' are current or potential employees and contractors. There are three main pay categories:
1.Shift-workers
All shift workers doing a particular job on a particular project are paid the same rates e.g. all welders on a particular project or site in England are paid the same as each other. For that reason I want to link the pay rates with the job description for these workers. This avoides creating 50 records for 50 welders on the site in England to say that they make £10 an hour normal time (or whatever it is) etc.
2. Contract
Contract workers usually get paid a flat rate per hour. As these are negociated on an individual basis I would need to have this information linked to each individuals job (M_CandidateJobDetails).
3. Salary
Again this information needs to be input for each individuals job.
For the contract and salary people the pay frequency can vary (weekly, bi-weekly or monthly). So can the currency they are paid in. I haven't got as far as the currency issue yet.
The reason for the one-to-many relationship between M_JobClassifaction and M_CandidateJobDetails is that many candidates can have the same type of job e.g. there can be many employees that in the job classifaction of 'Electrician'. For many of the jobs at managerial level e.g. 'site manager' there will only be one.
I will have a table with the hours worked by each person per week. I can use this for those on shift work or contract to calculate what they will be paid.
One of the main reasons for this database is so that the company can print reports to see what is paid out in payroll for each site and in total (in euros). These will be gross figures and I don't need to take expenses, vacations, bonuses or taxes into account. They other thing we will need to be able to do is assign candidates to vacant positions and change them from one position to another - possibly between different projects.
So basically does anyone have any comments on the relationships, normalisation or anything else. Is this the best way to do it?
I've attached a screenshot of the relationships.
View 13 Replies
View Related
Feb 18, 2014
Access Query. I am creating a time sheet / pay roll database and I want to be able to get a total of the daily hours in a query.
For example I have 'Mon Start' and 'Mon Finish' for Mondays in/out times and I have a 'Mon Total' which gives me the total hours worked for Monday.
The problem I have is that Mon Total only works if the hours are say between 07:00 and 17:00, anything after midnight (00:00) like 21:00 to 07:00 and 'Mon Total' goes crazy !!
At the moment 'Mon Total' is the result of CDate 'Mon Finish' - 'Mon Start' (bit rough I know).
View 3 Replies
View Related
Apr 28, 2015
The problem that I am having is how to recalculate all order detail item.
FORM
Main form = Tblorder : orderID, CustumerID, TotalSquare
Sub form = TblOrderdetail : orderdetailID, OrderID, itemname, unitprice, total
Example: if I set up the totalsquare FIRST = 10 and I select the the itemname, it will calculate the total = unitprice * totalsquare this work fine.
I have 20 item in sub form orderdetail and every item was calculate based on totalsquare = 10. For some reason, I have to change the totalsquare = 20.
How do I make so that it will recalculate all 20 items in subform/orderdetail instead of deleting all item and re enter it again?
View 5 Replies
View Related
May 20, 2014
I need to make an order purchase form like i have customer table and product table, i want to make a form which creates order for a specific customer and I can add as much items as i want and than calculate auto the total price, and an option to make a report for it.
View 5 Replies
View Related
May 3, 2006
I am trying to develop a simple payroll. I have already developed three tables named tblEbmployee, tblPayment, tblDate. These are related with one to many between tblEmployees and tblPayment and one to many between tblPayment and tblDate. I dont need much calculations in the system. I will add salaries in tblPayments of the employees manually (as there is no set formula relating to the salary an employee). What i need is:
To make a form which uses tblemployee for each month salary
To carry the previous month salary data to next month without adding date for each employee indiividually. (is there a way to change month once that applies to all employees, keeping the record of previous month ) Do i need to add some other table to keep record of previous month payments and a table keeping record of rate of salary
yours
Arshad Slatch
View 7 Replies
View Related
Sep 27, 2005
Hi All,
Need your expert advise. Is it ok to develop a simple payroll system using MS Access or do i need switch to Visual Basic?
Also, is there anybody can help what tables do i need to produce a payroll system, i.e. tblEmployee.
Thanks,
19Summer95
View 3 Replies
View Related
Dec 6, 2005
I am trying to type a code based on 1 & 2 criterias. However, I am having a problem on the first criteria because it is adding 8 hours when it shouldn't. Can someone help to either fix my code or write a new one? Thank you very much!
Criteria 1: If the day_of_wk is 1, calculate time-reg_time/60, If the day_of_wk is 1 and time is less than 0, calculate time-reg_time/60+24
Criteria 2: If the day_of_wk is 2, calculate time/60, If the day_of_wk is 2 and time is less than 0, calculate time/60+24
My code: pre: IIf([day_of_wk]="2",[time]/60,IIf([time]<0,([time]-[reg_time])/60+24,([time]-[reg_time])/60))
View 4 Replies
View Related
Jul 8, 2005
Hey there,
I have a form that has 7 days (Mon, Tue, Wed, Thur, etc...). The time is formatted like 08:00AM. Under each of those controls I have something that uses the expression: =(((([Sunday End Time]-[Sunday Start Time])*24)*60)/60), which if the hours were 08:00AM - 04:00PM, would give me 480, and then I convert it to hours (8). I have all these fields defaulted to 12:00AM to 12:00AM. I have another box that totals all these fields and uses the expression: =([SUH]+[MH]+[TU]+[WH]+[TH]+[FH]+[SAH]). These boxes are all of the results of End time-Start time. Now the problem. I have a payrate field on the form that looks at the hours worked, so I needed to separate overtime from straight. I have a box that looks like this: =IIf([Hours Worked]>"40",40,([Hours Worked])). The hours worked box is the result from the sum of SUH+MH+, etc...The problem is, each time I have any hours in there less than 10, it will return a crazy result. If I only enter 8 hours, it enters in the hours worked box: 40 hours. If I add 2 more hours, it fixes itself. What is the problem. I would be happy to send the file over, or ANYTHING to get this to work.
Sincererly,
Raymond
View 2 Replies
View Related
Jul 29, 2005
Hello excellent helpers,
Thanks first of all for the responses I always get on here.
Question: There are several number fields on my form that are calculate fields, which I will show later what the expression is, that are not rounding off to 2 decimals as I am asking it to. How do I fix this?
The expression: =(((([Wednesday End Time]-[Wednesday Start Time])*24)*60)/60). This is a control box located under two fields (Start time and End time). The fields are formatted as 08:00AM.
So if I did 08:00AM to 05:20PM, the result would be 9.333333333....This does not mean much for the day as it adds up to be only cents, but over the week it becomes dollars. If the actual number was 9.33, it would be ok. No use in explaining that, you all get the idea.
View 2 Replies
View Related
Oct 28, 2005
I'm trying to use a query to calculate the payroll for all the employees but it won't work. The two tables I have are 'Employees' and 'Employee Payroll'. In the 'Employee Payroll' table there are three fields- Employee ID, Days worked and Earnings. I need to calculate the sum of the earnings field but it just displays a blank list of records when I try it.
Can anyone help?
Thanks
View 6 Replies
View Related
Jul 17, 2014
I would like to create an Access Database that calculate due date based on 2 tables, one with invoices and supplier details. The other one with Supplier name et payment terms.
Input:
Table with the following details:
- Supplier Name
- Invoice Date
- Currency
- Amount
Output:
Table same as input but with a column that shows for each record the Due Date. The due date would be calculated by adding payment terms in days from another table to the Invoice date.
View 5 Replies
View Related
Nov 7, 2005
I am a modular housing sales consultant and I am trying to setup a work order database in access. This database would allow me to spec out a modular home for a prospective customer/client as they provide me with all of their home options (floors, exterior, doors & windows, interior, appliances, bathrooms, kitchen, etc.) and then print out an invoice with an estimated total.
I am currently using an excel spreadsheet and it is very cumbersome to use. I use it as an invoice and the invoice contains the following information on it.
Bill to:
Dealer Name
Dealer Rep
Phone, Fax, Cell
Ship to:
Customer Name
Customer Address
Phone, Fax, Cell
Home Options:
Floors:
Joist: (Structure Wood 2X8 Joist, Structure Wood 2X10 Joist, Plywood 2X10 Joist)
Carpet: (Cappuchinno, Biscuit, Pebble, Summer Straw, Praline, Herringbone, Cashew, Buckskin, Shale, Botanical, Cordovan, Stone, Cascade, Black Ice)
Vinyl Flooring: (Woodgrain #05296, Square Tile #57296, Mosaic #55296, Tan Stone #08296, Large Square Tile #07296)
Interior:
Interior Doors: (install, ship loose, 6 panel, flat)
Hardware: (Brass, Brushed Nickle, Round Knob, Level Handle)
Crown Molding: (4", 5")
Base Molding: (4", 5")
Appliances:
Color: (White, Black, Bisque, Stainless)
Dishwasher: (Standard, Power Scrub)
Microwave: (Over Range, Free Standing)
There are other options but this is just a brief listing of options as an example.
Each option would have a price attached, and selected price would be added to the invoice, and once work order is completed, the invoice would have options totalled. Ready for the customer and dealer to confirm and approve.
Can someone start me in the right direction on getting the tables setup for this - the one that I seem to be having the most difficulty with is how to setup the options for this invoice. I pretty well have a grasp on the others. I might also need help in relating the tables to one another.
I hope this all makes sense.
Any help would be greatly appreciated.
Donm
View 2 Replies
View Related
Mar 19, 2007
Hi, I wonder if anyone could help. I'm in the planning stages of creating a order manager in access for multiple ecommerce sites.
Database will store data on Customers, Inventory, Invoices, Returns, Shipments, Credits, Quotes etc for all sites, and also custom reports. And the idea is to have the database generate the ecommerce sites automatically as static html, which can be uploaded. As the orders come in they will be stored online, and then periodically downloaded into the database.
The reason is we currently have 3 sites running and managing inventory and stock control is the hardest, as currently there are 3 databases controling stock! Also when a customer telephones its difficult to know which site they have ordered from which is unprofessional, and we have to log into every site just to find their order.
Future ideas:- Meaning we are going to setup more sites which will obivously make the situation worse. We also want to branch out in into eBay using the eBay API to download transactions and sales, and will therefore need a place to store the data.
Can anyone foresee any problems with such a system? Any ideas or examples?
Thanks for your time.
View 2 Replies
View Related
Apr 7, 2008
Hello,
I am basically doing FORM to automatically figure out my stylists commission pay, based on 5 levels of sales and 3 different pay levels, that I will cut and paste in a table from my POS system.
3 Total Tables.
tbl_Employees, with the headers ID, Name, Payroll ID, Comm_Level.
tbl-Current Year with the headers ID, Payroll ID, Name, Service Sales.
tbl_Comm with the headers ID, CommLow, CommHigh, Level1, Level2, Level3
In a query, Qry_Years, I have Payroll ID, linked between the tbl_Employees and tbl-Current Year.
I am close in a FORM to getting this to work, unless DLookup is the wrong why to go about this.
This is not correct, but gives you an idea of what I am trying to do. In a FORM text box (called framePayrollIDLookup) I have
=DLookUp("Level1","tbl_Comm",[tbl - Current Year.Service Sales] & " between [CommLow] and [CommHigh]").
This pulls up the correct pay percent for level1 employees, but i need to change out Level1 to something variable.
This also doesn't work, but gives you an idea of my though process.
=DLookUp(" " = framePayrollIDLookup,"tbl_Comm",[tbl - Current Year.Service Sales] & " between [CommLow] and [CommHigh]"), but this doesn't work.
I might be way off base on how to do this, but I am trying. Thanks for any help.
Chris
View 14 Replies
View Related
Jun 12, 2007
Hi,
I am trying to design and build an orders management database for a clothing wholesaler.
Has anyone got any ideas on what entities i should have.
I thought:
Clients (Customer Details)
Orders (Inc. order date, ship via etc)
Order Details (sizes, quantity of orders per size)
Product Details (Product Code, colour, size, stock numbers per size)
Catergories (Shorts, Jackets, Jeans etc)
Suppliers (Supplier Information)
Delivery (Delivery Method etc)
However, loads of problems when i come to planning the sizes part. I have different product catergories with different sizes
And when i do the order details table, i need to enter order quantities for each different size for one clothing unit.
Any ideas?
I would also ideally want to link the order details and products tables by the product code number. I.e. When filling out an order In the order details table i want to type in the product code then have information from the product table automatcially fill in the gaps in the order details table, such as unit price, colour etc.
Hope you understand and can help me!!!
Thanks for your time
J
View 9 Replies
View Related
Jun 22, 2013
Access database to calculate income tax?
I'd like to be able to input the amount I invoice each month into a table and it would calculate Vat and Income tax due.
I'm sure its been done many times before however I cant find any examples.
View 1 Replies
View Related
Dec 30, 2014
Any method by which one can calculate the Percentile Ranks for the IV Implied Volatility in a Stock Market Database ?
IV Percentile rank simply tells us whether implied volatility is high or low in a specific underlying based on the past year of IV data. For example, if XYZ has had an IV between 30 and 60 over the past year and IV is currently at 45, XYZ would have an IV rank of 50%.
My table has got the IV Value for each symbol for the past one year and I need to calculate the IV Percentile Rank for each symbol based on this past one year data.
View 1 Replies
View Related
Sep 14, 2014
I have the attached database which calculate the Difference between dates.I have also two problems like i shown in the image
Code:
Option Compare Database
Option Explicit
Sub Recalculate()
Dim rst As DAO.Recordset
Dim dff As Long
[code]...
View 4 Replies
View Related
Jun 23, 2014
I need to have a field in a database that will calculate the age of a person, based on their DOB. I have it in the excel sheet that I imported into Access to create the data base, but it just copied the number that was already there. When I add new entries into the database, the age isn't calculated. How do I do this?
The forumla I use in my spreadsheet is: =DATEDIF(O2,TODAY(),"y")
View 1 Replies
View Related
Sep 6, 2005
I have taken the Order Entry database sample from Microsoft and have added a "Wizard" type interface.
Question) I'm having trouble understanding how to get more than one Feature applied to a single new service.
- For example, If I add a new SERVICE to an ORDER, and I need to add all available FEATURES to that SERVICE, how do I do that? *see my attached database & relationships. The form of FEATURES is also attached. I just want to be able to check off the ones that apply.
(is this many to many? I tried a junction table but can't make it work)
I would really appreciate some advice on my Forms, and definitely advice on my Table / Relationship structure.
ps: My tblServices use to be called tblProducts. I then added the tblCategories, tblPaid, tblTeleServ, tblLongDistRate, tbl800Serv & tblFeatures.
Thanks in advance for your help,
jlig
View 1 Replies
View Related
Nov 22, 2012
I am new to Access. I am creating a simple order/payment database.
I have tables for the orders and payments and have a relationship setup.
I created an order form with a subform for the payments.
[URL] .....
View 2 Replies
View Related
Aug 27, 2014
I have a table called tbl_Employee. The employee's hourly rate is one of the columns. I want to create a forecasting schedule that will find the work days between two dates, multiply by 8 (hours per day) and multiply by the hourly rate.
For example, Employee A has rate of $100/hr. We forecast they will work 250 work days from January 1, 2014 to January 1, 2015 so 250*8*100= $200,000.
However, on June 1, the rate for Employee A increases to $110. So the new forecast would be (125*8*100)+(125*8*110)=(100,000+110,000)=$210,000 .
How can I account for something like this?
View 2 Replies
View Related
Oct 22, 2014
I would like to create a payroll record that collect some information from another table. In other words:
-I have an employee.
-I have a payroll table.
-I would like to get some of the values from the employee table written to the payroll table when a new record is entered.
The form would look some thing like this:
Three boxes:
Employee: [ ] (table query to find name) # of students [ ] #of class minutes [ ] (value list with 3 choices)
When the SAVE button is pressed a record would be written to the payroll table with:
The payroll table would look like this:
payrolid#, employee#, employee, # of students, # of class minutes, rate, date
The employee#, employee and the rate would come from the employee table.The # of students, # of class minutes and date would come from the payroll form.
View 7 Replies
View Related
Feb 28, 2005
I have 2 databases Product, with 3 entries ProdID, ProdName and UnitCost.
2nd database Order has Order ID, ProdName, UnitCost, Quantity, SaleDate and Total.
I want to create a form to input data into the Order databse that allows me to enter several rows using the data from the product table by selecting ProdName(Product) from list and UnitCost(Product) being inserted into each row automatically as a new ProdName is selected.
Can anyone hsuggest how best to do this.
View 4 Replies
View Related
Jan 12, 2015
I'm currently making a database for college about a driving school.
I have a table that stores the following: booking id, student id, lesson id, student forename, student surname, cost per hour and date paid.
How to create a query that calculates the total of the lessons taken in a month.
View 4 Replies
View Related