Calculate Payroll In Order Database

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 !

---

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 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 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 !

---

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 !

---

Help With A Word Order Database
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 Replies !

---

Order Manager Database
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 Replies !

---

Help With Clothing Order Management Database
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 Replies !

---

Order Entry Database Problem With Pop-Up Subform
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 Replies !

---

Multiple Lines In Order Form From Single Database
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 Replies !

---

Calculate A Value
How would i go about getting the field 'GMargin' (Gross Margin) to be calculated from subtracting 'SellingP' from 'PurchaseP' (Selling and Purchase Prices)?

How do i do this? Help me please :)

View Replies !

---

Calculate
I have a field which I enter a short time such as 3:13, 5:45, etc

Now i am creating a report which at the end of the report I would like to include an unbound text box, which displays the total amount of time for that field (pls note that the total will never exceeds 24 hours) What is the best formula to use in order to calculate this ?

Cheers

View Replies !

---

Calculate Hh:mm To Mm
Hello,
I am trying to sum minutes from a database using an Access query, but the format in the database is hh:mm. I know the query to use in Oracle:
ROUND(SUM((substr(actual_time,1,(instr(actual_time ,':' )-1))) *60 + (substr(actual_time,(instr(actual_time,':' )+1),2)))
but not sure of the syntax to use in an Access expression.
Any ideas?:confused:

View Replies !

---

Excel Can´t Calculate.
HI,

Excel is having difficulties calculating a workbook of mine. It complains about cirkular references, so I had to set the iterations manually.

The workbook holds about 5000 records and I´m using a cosinus function.

The thing is I don´t know what to do. Excel calculates the workbook, but it doesn´t do it right. What setting should I use with the iterations?

I´m thinking of running it in excel 97. Will that help?

I really need to be able to run this workbook. Does anyone have an idea?

Fuga.

View Replies !

---

One PC Not Able To Calculate Formulas Ect.
Hello, I didn’t know how to explain this or where to post this but here we go! I have two databases and one of the PC's here at work can’t use some of the items in the database like on one of the databases there is some formulas in text boxes and that PC won’t calculate what’s needed in them and every PC in the plant will except for this one PC. Also the one PC won’t bring up the Allen Browne's Calendar. When you press the start or end button to bring up the calendar it never pops up but if I enter the start date and end dates and use it that way ect then it works. I have no clue why this is just happening to this one PC. Any ideas?

View Replies !

---

Date Calculate
I want to calculate a data from anthony table, like (20 Jan 2005) + 365 days
will be 20 Jan 2006, how can i do it.

The Table setting is just like below:
Constituent (DataID,...);
Student (DataID, DOB,...);
School (DataID, 4YearsOld(As a Date Format),...)

Anyone can help me, Thank you.:)

View Replies !

---

Calculate Age Using Queries
i have a table with fields "[DATE OF BIRTH]", "age", "temp-age"

i have a query that calculate the age:
example; the query will get user to input the "temp-age" and upon "temp-age" is input and "ok" on the query, it will calculate a person's age and store the value inside table "age".

however, the calculated value for the age have some data problem. for example, when a person whose age is yy:mm 24:05 the age inside the table will be 1924:05. there will be a additional "19" at the age.

what cause the additional "19" problem?
---------------------------------------------------------------------
my query in design view is like this; (see attachment)
it uses " [temp-AGE]-[DATE OF BIRTH] " to calculate the age and store into table "age".

View Replies !

---

Calculate A % Of Total.
I have a query that returns a number of calls recieved of a certain type for each week of the year. Wnat I want to do is calculate the % of those type of calls of the total calls for each week. Below is my querey

SELECT datepart("ww",DateLogged) as Week_Number,
COUNT(CallType) AS call_count,
FROM tblLog
WHERE CallType = 'Software/May-PS' OR CallType = 'Report Regeneration-PS' OR CallType = 'Training/Info-PS'
Group By datepart("ww",DateLogged);

View Replies !

---