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

MikeL

Active Member
Joined
Mar 17, 2002
Messages
492
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
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. :(
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,223,888
Messages
6,175,207
Members
452,618
Latest member
Tam84

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top