Search results

I need a table to store pay rates and how they change with time. Let's say there are two classes of workers (class A, class B) and each class has two levels (level 1, level2). The rates change periodically and I want to retain the historical rates. If I were doing this in Excel I would use a...

Yes, I have some more thinking to do. It feels like I'm not making much progress but I hope things will start to gel soon.

Ok, thanks for asking, here's what I'm working on. It's only a small piece of what this project will become but I am building it in pieces, as I need to learn how to do just about everything. This part is to track how various attributes of employees, change over time (dates). Some questions...

Sorry, I think I understand your answer better now and see how it will work!

Ok thanks but I see I wasn't clear. I need to keep track what dates each attribute value was in effect for each employee, i.e. retain the date history of the value changes. I'm hoping to be able to specify a date in a query and see what an employee's values were on that date.

I have a list of employees. For each employee, I want to track attributes that change over time. Let's say there are 2 attributes, "level" and "stage". Level and stage vary independently. I could maintain a table for each employee, like this: Date Level Stage 2018-06-01...

I posted a simplified version of the database to ask a basic question. I'll need to flesh it out quite a bit but I'm still wandering in the wilderness regarding the options for design. Some questions for the patient: Is it better to use a data field for the primary key, provided there are no...

This is being a great help. I have now read up a bit about normalization. Unsurprisingly, it seems there are many different ways to achieve the same result. CJ_London suggests 6 tables while Pat Hartman kindly fixed my database while staying with just 3 tables. I'm not sure which way to go but...

Thanks CJ_London. Your reply suggests an approach I had not thought of. Classification is an attribute of each employee and changes over time. Each classification has a particular hourly rate, which also changes over time. I had been trying to calculate the costs (rate*hours) when the hours...

I'm posting my first question, having read the newbie guides. I have little knowledge but much desire. I would appreciate any guidance. I am developing an application to track labour hours and costs by project. I've attached a prototype database with 3 tables: Labour - contains employee...

Thanks everyone!

I've had many years developing database-like applications in Excel but I now have a project I need to do in Access. Having only limited experience with Access I have been googling a fair bit and AccessWorld appears often in the search results so I decided to create an account so I could ask a...