Hi, Background.....
I have a table with several fields including EMPLOYEE, DATE and AMOUNT. I created an UPDATE QUERY to multiply AMOUNT by 60% when the DATE is EQUAL TO FRIDAY JAN 14. This works and $100 becomes $60 for that EMPLOYEE on that DATE.
However, there is a second query which joins the columns to a STATE table on EMPLOYEE. When I run that query second, ie after the one above the EMPLOYEE is at 100 dollars and not at 60 dollars.
Cant share data but any idea why this is?
Thanks in advance.
Mike
I have a table with several fields including EMPLOYEE, DATE and AMOUNT. I created an UPDATE QUERY to multiply AMOUNT by 60% when the DATE is EQUAL TO FRIDAY JAN 14. This works and $100 becomes $60 for that EMPLOYEE on that DATE.
However, there is a second query which joins the columns to a STATE table on EMPLOYEE. When I run that query second, ie after the one above the EMPLOYEE is at 100 dollars and not at 60 dollars.
Cant share data but any idea why this is?
Thanks in advance.
Mike