Any ideas why the update query fixes the blanks but not the sorghum name? Thanks.
T tanyamc Registered User. Local time Today, 15:21 Joined Mar 7, 2019 Messages 43 Mar 12, 2019 #21 Any ideas why the update query fixes the blanks but not the sorghum name? Thanks.
MajP You've got your good things, and you've got mine. Local time Today, 17:21 Joined May 21, 2018 Messages 8,552 Mar 12, 2019 #22 I would think something more like Code:Copy to clipboard UPDATE NAP_Crops_Dupl_Table SET [Crop Name] = 'Sorghum Dual - Purpose' WHERE [Crop Name] = 'Sorghum, Dual Purpose'
I would think something more like Code:Copy to clipboard UPDATE NAP_Crops_Dupl_Table SET [Crop Name] = 'Sorghum Dual - Purpose' WHERE [Crop Name] = 'Sorghum, Dual Purpose'
T tanyamc Registered User. Local time Today, 15:21 Joined Mar 7, 2019 Messages 43 Mar 12, 2019 #23 I had to do two separate update queries. Otherwise I got syntax errors. I think it is working correctly now! Many thanks!
I had to do two separate update queries. Otherwise I got syntax errors. I think it is working correctly now! Many thanks!
MajP You've got your good things, and you've got mine. Local time Today, 17:21 Joined May 21, 2018 Messages 8,552 Mar 12, 2019 #24 I had to do two separate update queries Click to expand... Yes, much easier to do multiple updates.
T tanyamc Registered User. Local time Today, 15:21 Joined Mar 7, 2019 Messages 43 Mar 19, 2019 #25 A coworker suggested doing it within the queries I already had, rather than doing the update method. It worked! Thanks!
A coworker suggested doing it within the queries I already had, rather than doing the update method. It worked! Thanks!