Payroll Form
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 Complete Forum Thread with Replies
Related Forum Messages:
Trying To Create An Automatic Payroll Form
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 Replies !
Payroll Help
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 Replies !
Payroll System
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 Replies !
Payroll Calculation
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 Replies !
Payroll Dilemna
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 Replies !
Employee Payroll
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 Replies !
Calculate Payroll In Order Database
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 !
Payroll Database- Advice Needed On Relationships/normalisation
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 Replies !
Open Previous Form From Current Form Sub Form
I have a fault form which the user enters details of a fault. When the fault form is submitted the data is saved in the relevant table and the form is cleared so that the user can enter the next fault. On the fault form i have a subform which displays the faults previously entered by the user. I want the user to be able to click on an entry in the subform and open the orignal fault form and see the data that had been entered. How can i create this functionality??
View Replies !
New At Access: Update Simlar Text Fields In One Form Based On Another Form
I am very new at Microsoft Access. I have two forms, A and B, that are filled out by two different users. Form A gets filled out first than form B gets filled out. Each has a name box as well as a birthdate box and a few other similar text fields. However, each form also has a few distinctive fields. I was wondering how I could input the common information in Form A to Form B so the user of Form B does not have to spend time retyping the name and birthdates again. In other words, I want to synchronize the similar records between the two forms. I would like the values to appear in a table as well. I would greatly appreciate it if someone could help me with the visual basic code. Thank You.
View Replies !
Open Form Command Button Fills In Text And Date Fields From Previous Form
I currently have two forms: frmE_SAFind and frmE_SAOrder frmE_SAFind shows results from a query including fields [txtIDPO] and [dtmDate] Example: IDPO Date btnOpnFrm 6543 2/1/05 btnOpnFrm 5681 1/1/05 frmE_SAOrder shows order details including [txtIDPO] and [dtmDate] I have a open form command button set up on [frmE_SAFind] that opens [frmE_SAOrder]. Is it possible for me to modify its properties so that when the open form command button is clicked, the order details in [frmE_SAOrder] will represent the order that the user is selecting via the btnOpnFrm command? Example: If I click btnOpnFrm for 6543, [frmE_SAOrder] will show me PO 6543 details. Hopefully I made myself clear enough to understand. Thanks for your help!
View Replies !
Parent Form Vanishes When I Tab To Option Group In The Child Form?!
I have a rather annoying and frustrating problem which I cannot find a solution for through searching the forum. The situation is that I have a parent form with 1 unbound subform, the source of which is determined by the part number selected in the parent form (diffetrent parts have different fields of the source table displayed) This all functions perfectly well in all but one case which is when the source of the subform is a form with an option group. There is only 1 form like this, and the problem I have is that when tabbing through the fields, as soon as I tab into the option group the parent form disappears, and I am left with just the subform on screen! Clicking into the group is fine, just tabbing to it causes the problem, and if I remove the option group then tabbing through all the rest of the fields is fine... I could powssibly change the option group for a set of option buttons and code them to function a bit like an option group, but this would mean changing the code for numerous reports etc. and I don't really want to do that if I can help it.
View Replies !
Update / Refresh A Form Upon Entering Data In A Popup Box / Form
I apologize if this has probably been asked countless times; however, in my search of this forum I could not find something that seemed to work for something so simple. ************************************************** Scenerio: I have 2 forms. The first form is my main form and the second form is my "popup" form. Both of these forms access the same table. In my main form I have it so people can not enter in a ID so it reduces accidental data entry. Therefore, I created a "popup" box that allows ID entry. Everything works great except when I close out of the popup form, the newly entered data is not available unless I close the main form and reopen. Million Dollar Question: How do I refresh or requery (dunno the correct term usage here) the main form to reflect the addition I made in my popup form. I would like the refresh event to happen when I click the close button on my popup form. ************************************************** Again, I know this is probably simple, but I cannot find it anywhere or most likely I am blind :cool: Thank You
View Replies !
|
TRACKER
