I have three queries: the first calculates total hours that an employee has worked (from weekly hours in a table) on a certain project on a certain month and year. the second is a subquery of the first, and calculates the the sum_of_total_hours * billing rate and creates the cost to charge for that labor for the month. Finally, the 3rd query is a sub of the 2nd, and calculates the total cost per month for a certain project.
Assuming a perfect world where there is only one month and one project, everything works fine. The problem is when there are multiple people working on multiple project on different months.
When I combine this information into a report or a 4 main query, the information is duplicated many times. Naturally since I am quite new to Access, I do not really know what to do. I was fiddling with the join properties but they dont seem to make a difference.
Can anyone point me in the right direction?
Thanks,
Damian
Assuming a perfect world where there is only one month and one project, everything works fine. The problem is when there are multiple people working on multiple project on different months.
When I combine this information into a report or a 4 main query, the information is duplicated many times. Naturally since I am quite new to Access, I do not really know what to do. I was fiddling with the join properties but they dont seem to make a difference.
Can anyone point me in the right direction?
Thanks,
Damian
