By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,135 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Update Query is not working

P: 91
The update query is not working and I cannot understand why. I have attached the screenshots with SQL and Design view.

Expand|Select|Wrap|Line Numbers
  1. UPDATE DetProcess INNER JOIN RiskDetailsTable ON DetProcess.DetProcessID = RiskDetailsTable.DetProcessID SET RiskDetailsTable.DetProcessID = [DetProcess].[DetProcessID];
Kindly advise.

Many thanks,
Attached Files
File Type: doc update query.doc (404.0 KB, 155 views)
Mar 14 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,307
How can you tell if it's working on not? You're setting the value to exactly what it must already be to qualify to be updated at all o.O

PS. If you post pictures as JPEGs we can see them. I'm just working from the SQL.
Mar 14 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.