Hi,
I am inexperience with databases and access and would welcome some assistance on a problem I am having with my table structures.
From our time sheet system I am able to get a dump of employee ID, date , hours, cost code, etc I have been able to link this to employee name and cost code description tables with no issues. The problem I am having is the project has a set of hourly charge rates which is dependant on the organisation you work for, the date the hours were incurred and the agreed project category (position) of the employee. I have create a table with the organisation, rate effective from date and project category as primary keys and other fields for the rate etc. I then have been trying, unsuccessfully, to get this table related to the others with no joy. When I run a query to multiple the hours by the rate for each cost code each entry in the time sheet get all the rates applied rarher than the correct rate i.e. multi entries for the same hours. Any assistant guidance would be great.
Thanks
Paul
I am inexperience with databases and access and would welcome some assistance on a problem I am having with my table structures.
From our time sheet system I am able to get a dump of employee ID, date , hours, cost code, etc I have been able to link this to employee name and cost code description tables with no issues. The problem I am having is the project has a set of hourly charge rates which is dependant on the organisation you work for, the date the hours were incurred and the agreed project category (position) of the employee. I have create a table with the organisation, rate effective from date and project category as primary keys and other fields for the rate etc. I then have been trying, unsuccessfully, to get this table related to the others with no joy. When I run a query to multiple the hours by the rate for each cost code each entry in the time sheet get all the rates applied rarher than the correct rate i.e. multi entries for the same hours. Any assistant guidance would be great.
Thanks
Paul