alright... just figured it out... had to change the linkages between queries and tables in order to get the information to flow properly and eliminte the duplicates
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.