AC5FF
Registered User.
- Local time
- Yesterday, 20:19
- Joined
- Apr 6, 2004
- Messages
- 552
Not really sure why this happens, but I have an update query I would like to run to update a Y/N field. I initially wrote the query as a Select query to test the data results would be what I was expecting. Pretty easy, I just want to see the latest entry by date of an account number's reply. Here is that Select query:
This gives me 7 results out of my test group of data. Exactly what I would expect to see. Yet when I add one more field to view in this query and make it an Update query I loose all of this previous query and all I have is:
Running this update will update 15 rows of my table - not correct.
So, I tried to run an update query off of my first query above that gives me the correct 7 rows. But doing this I get an error "Operation must use an updateable query"
I'm not sure how to get around all of this. Out of my table of 700+ lines I've gotten queries to give me the 7 results I would expect to see, but I cannot get a query to update those specific rows.
Any ideas?
Code:
SELECT Max([ZZZero Testing].Response_Date) AS MaxOfResponse_Date, [ZZZero Testing].[ACCT NUMBER]
FROM [ZZZero Testing]
GROUP BY [ZZZero Testing].[ACCT NUMBER]
HAVING (((Max([ZZZero Testing].Response_Date)) Is Not Null));
This gives me 7 results out of my test group of data. Exactly what I would expect to see. Yet when I add one more field to view in this query and make it an Update query I loose all of this previous query and all I have is:
Code:
UPDATE [ZZZero Testing] SET [ZZZero Testing].UseResponse = 1
WHERE ((([ZZZero Testing].Response_Date) Is Not Null));
Running this update will update 15 rows of my table - not correct.
So, I tried to run an update query off of my first query above that gives me the correct 7 rows. But doing this I get an error "Operation must use an updateable query"
I'm not sure how to get around all of this. Out of my table of 700+ lines I've gotten queries to give me the 7 results I would expect to see, but I cannot get a query to update those specific rows.
Any ideas?