Dean Davids
dnod at aol.com
Tue Jul 19 10:13:19 CDT 2011
If you do that kind of thing in a QBE window, you can preview the results before committing the results. I do that always. Still, it is a bit scary when you push that action button and then look for unexpected issues. Dean S. Davids www.cmbscorp.com 954-868-4421 On Jul 19, 2011, at 11:00 AM, Charlotte Foust <charlotte.foust at gmail.com> wrote: > I'll never forget the time a developer who worked for me decided to update > all of a certain numeric string to a text number in an address field. The > query ran and worked...sort of. He had forgotten to provide for spaces > around numeric string. I had to go through thousands of records and find > every instance of "two" in a longer number and replace it with "2"! > > Charlotte Foust > > On Tue, Jul 19, 2011 at 3:46 AM, Susan Harkins <ssharkins at gmail.com> wrote: > >> No, they were both text -- I checked that and Access automatically knew >> that the field was text and took care of it for me. I never call myself an >> expert. :) >> >> Susan H. >> >>> >>> Your query may have tried to update a text 20 to a numeric 21, which would >>> have been the wrong type and should not have worked. >>> >>> Just a guess ... >>> >>> Dan >>> >>> PS - Don't ever tell anyone you're an expert. As soon as I said it - I >>> wasn't! :-( >>> >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd> >> >> >> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com> >> >> >> > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com