Beginner Question on Update Query changing value in table but not in other query when joined to another table

[MikeL]

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

 

[welshgasman]

I always start with Select query, then change it to Update/Append/Delete.

So in the select, does that record even get shown?

You probably have your join incorrect.

 

[Micron]

You probably have the $100 stored in two or more fields. That would be bad, but so is storing any calculation 99% of the time.
If you don't store the 100 in more than one field, then maybe posting the sql of both queries (please use code tags) would help if welshgasman's suggestion doesn't lead to a solution.