使用更新查询来更改值的一部分？ [英] Using Update query to change a part of a value?
问题描述
我在MS Access 2003中工作，我想使用更新查询来更改字段中的部分值。我有一个包含大量记录的姓氏字段。有人进入了De Pedro和De La Rosa等人的价值观，而我的老板则希望他们是小佩德罗和德拉罗莎。我想更新De到de而不必手动更改它们。我尝试了标准Like * De *并更新*" de" *但是整个名称都替换为de。如何在不覆盖名称的其余部分的情况下用de替换De？我很感激你的专长。 Rusty
I am working in MS Access 2003 and I want to use the update query to change part of a value in a field. I have a last name field that contains a lot of records. Someone entered the values De Pedro and De La Rosa etc. and my boss wants them in lower case de Pedro and de la Rosa. I want to update De to de without having to manually change them. I tried criteria Like *De* and update *"de"* but the whole name is replaced with de. How can I replace De with de without overwriting the rest of the name? I would appreciate your expertise. Rusty
推荐答案
嗨Rusty Boyd女士，
我会把这个帖子移到访问论坛，哪里更好合格的专家更有可能看到它......
我希望他们可以帮助您进行查询
Hi Ms Rusty Boyd,
I''ll just move this thread to the access forum, where better qualified experts are more likely to see it......
I hope they can help you with your enquiry
Hi Rusty Boyd女士，
我会把这个帖子移到访问论坛，更有资格的专家更有可能看到它。 ....
我希望他们可以帮助您查询
Hi Ms Rusty Boyd,
I''ll just move this thread to the access forum, where better qualified experts are more likely to see it......
I hope they can help you with your enquiry
我感谢您的帮助，我是新来的这个环境。 Rusty
I appreciate your assistance, I am new to this environment. Rusty
启动新查询并输入sql视图。输入以下SQL替换tblTable，其中包含要更新的表的名称，使用您要更新的字段名称替换lastName。 Access会提示您询问是否可以更改x记录数量。完成后，只需更改de Pedro即可。和De Pedro到de la Rosa和De La Rose分别。
Start a new query and enter sql view. Enter the below SQL replacing tblTable with the name of the table you want to update and lastName with the field name you want to update. Access will prompt you asking if it''s alright to change x amount of records. After completion just change "de Pedro" and "De Pedro" to "de la Rosa" and "De La Rose" respectively.
这篇关于使用更新查询来更改值的一部分？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
