actually no they are not dependent on hours worked. They are dependent on how long a person has been with the company and only earned if there is a timesheet...

The query errors out stating the update query generated multiple rows. I understand the update query needs to generate a single value - but not sure how to change...

I have added the query that I had created but it is giving me errors.

Thanks

Chris,

I did correct the data and ran the updated query as provided by you. I am still getting the rounding error. For example, I changed a few hours and rate...

Chris,

Thank you so much - it works except for the rounding.

I tested it with different hours and in some cases the total salary for the employee ends up being...

Chris,

I added 2 new columns - NewAmount and NewRate (The newamount is based on the calculated newrate)

The desired result is the existing Amount Column values to be replaced with...

Thanks - Chris

Thanks ColdCoffee - the equal sign was the issue.

Here is the error message - thanks.

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '>'.

Thanks!

Sean,

you are correct some of the tables have a multiple records.

Does the query syntax correct for joining multiple tables.

select a.dtimesheetid,b.dtimesheetid,c.dtimesheetid, d.dtimesheetid,e.dtimesheetid,f.dtimesheetid

from tblPRTS as...

Thank you Evil Kraig and Andre the following query worked great: I do have one more request.

I have another query that joins the below listed query which has three...

Andre thanks - I believe we are almost there. Here is more detail on the issue. I have a single table.

Vendor# Purchases ...

Sorry Andre,

I omitted one key item in the request. I would like the max date for by a field in my table called vendor.

The suggested query works as it returns...

Thanks Mark - that worked.