Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query not Updateable - using a subquery
Thank you, I tried to forget about those things. I'll give it a try. The subquery should work though. I use them off and on, sometimes they just run other times I have to do a work around. This is great ins SQL Server. Ken- KGPinard
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Query not Updateable - using a subquery
The following won't execute as "Query Not Updateable" What I'm trying to do is get the maximum Original Collection date [OriginalCollectionDate], for each Job from the raw data. The [Raw Data full set] and [Raw data Enhanced Full Set] are a 1 to 1 relationship (ID fields are the keys). The Raw...- KGPinard
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
