{"id":44,"date":"2013-09-15T02:39:12","date_gmt":"2013-09-15T02:39:12","guid":{"rendered":"http:\/\/access-diva.com\/blog\/?p=44"},"modified":"2015-12-30T22:08:34","modified_gmt":"2015-12-31T03:08:34","slug":"update-query-samples","status":"publish","type":"post","link":"https:\/\/access-diva.com\/blog\/?p=44","title":{"rendered":"UPDATE Query Samples"},"content":{"rendered":"

Simple UPDATE query\u2026<\/p>\n

\r\nUPDATE YourTable SET YourTable.YourField1 = "Your Value";\r\n<\/pre>\n
Update a field in your table with values from another field in your table\u2026<\/p>\n
\r\nUPDATE YourTable SET YourTable.YourField1 = [YourField2];\r\n<\/pre>\n
Update a field based on a field on your form\u2026
\nNote:<\/strong>\u00a0 The form must be open to perform this action!<\/p>\n
TEXT<\/strong><\/p>\n
\r\nUPDATE YourTable SET YourTable.YourField1 = "YourValue"\r\nWHERE (((YourTable.YourField2)=[Forms]![YourFormNameGoesHere]![YourTextBoxOrComboBox]));\r\n<\/pre>\n
NUMERIC<\/strong><\/p>\n
\r\nUPDATE YourTable SET YourTable.YourField1 = 1234\r\nWHERE (((YourTable.YourField2)=[Forms]![YourFormNameGoesHere]![YourTextBoxOrComboBox]));\r\n<\/pre>\n
Remember…\u00a0 Change the names to match your Fields, Tables, Forms, Controls, etc… to match yours.<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
Simple UPDATE query\u2026<\/p>\n
 UPDATE YourTable SET YourTable.YourField1 = "Your Value"; <\/p>\n
Update a field in your table with values from another field in your table\u2026<\/p>\n
 UPDATE YourTable SET YourTable.YourField1 = [YourField2]; <\/p>\n
Update a field based on a field on your form\u2026 Note: The form must be open to perform this action!<\/p>\n
TEXT<\/p>\n
 UPDATE YourTable SET YourTable.YourField1 […]<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[72,52],"tags":[18],"class_list":["post-44","post","type-post","status-publish","format-standard","hentry","category-queries","category-update","tag-queries","odd"],"a3_pvc":{"activated":true,"total_views":551,"today_views":0},"_links":{"self":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/44","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=44"}],"version-history":[{"count":3,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/44\/revisions"}],"predecessor-version":[{"id":287,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/44\/revisions\/287"}],"wp:attachment":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=44"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=44"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=44"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}