更新查询帮助 [英] Update query help
问题描述
我将记录导入到一个表中,后来发现其中许多记录在其中一个字段中有* b $ b尾随空格。如果我早点抓住它,我可以在导入之前修剪空格。
这不会工作(没有改变):
UPDATE tblManuals SET tblManuals.PARTNUM = Trim([partnum]);
有人请告诉我如何更新查询以修剪
空格?
I imported records into a table, later found out that many of them had
trailing spaces in one of the fields. If I''d caught it sooner, I could have
trimmed the spaces before the import.
This wouldn''t work (nothing changed):
UPDATE tblManuals SET tblManuals.PARTNUM = Trim([partnum]);
Would someone please tell me how to do an update query that will trim the
spaces?
推荐答案
Randy,
创建一个查询中的新字段并输入以下表达式:
MyUpdateField:Trim([partnum])
然后将查询更改为更新查询并输入此表达式它在哪里说
在PartNum字段中更新到:
MyUpDateField
-
PC数据表
您的资源以获取Access,Excel和Word应用程序的帮助
re ***** *@pcdatasheet.com
www.pcdatasheet.com
&q uot; Randy Harris < RA *** @ SpamFree.com>在消息中写道
新闻:aU *************** @ newssvr31.news.prodigy.com。 ..
Randy,
Create a new field in your query and enter this expression:
MyUpdateField:Trim([partnum])
Then change the query to an Update Query and enter this expression where it says
Update To in the PartNum field:
MyUpDateField
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:aU***************@newssvr31.news.prodigy.com. ..
我将记录导入表中,后来发现其中许多记录在其中一个字段中有尾随空格。如果我早点抓住它,我可以在导入之前修剪空格。
这不会起作用(没有改变):
UPDATE tblManuals SET tblManuals .PARTNUM =修剪([partnum]);
有人请告诉我如何更新查询以修剪
空格?
I imported records into a table, later found out that many of them had
trailing spaces in one of the fields. If I''d caught it sooner, I could have
trimmed the spaces before the import.
This wouldn''t work (nothing changed):
UPDATE tblManuals SET tblManuals.PARTNUM = Trim([partnum]);
Would someone please tell me how to do an update query that will trim the
spaces?
>
" PC数据表" <无**** @ nospam.spam>在消息中写道
news:b0 ***************** @ newsread3.news.atl.earthl ink.net ...
"PC Datasheet" <no****@nospam.spam> wrote in message
news:b0*****************@newsread3.news.atl.earthl ink.net...
Randy,
在查询中创建一个新字段并输入以下表达式:
MyUpdateField:Trim([partnum])
然后将查询更改为更新查询并输入此表达式,其中
在PartNum字段中显示Update To:
MyUpDateField
完美。我应该想到这一点。谢谢!
-
PC数据表
您的资源获取Access,Excel和Word应用程序的帮助
re ****** @ pcdatasheet.com
www.pcdatasheet.com
" Randy Harris" < RA *** @ SpamFree.com>在消息中写道
新闻:aU *************** @ newssvr31.news.prodigy.com。 ..
Randy,
Create a new field in your query and enter this expression:
MyUpdateField:Trim([partnum])
Then change the query to an Update Query and enter this expression where it says Update To in the PartNum field:
MyUpDateField
Perfect. Should have thought of that myself. Thanks!
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:aU***************@newssvr31.news.prodigy.com. ..
我将记录导入表中,后来发现其中许多记录在其中一个字段中有尾随空格。如果我早点抓住它,我可以在导入之前修剪空格。
这不会起作用(没有改变):
UPDATE tblManuals SET tblManuals .PARTNUM =修剪([partnum]);
有人请告诉我如何进行更新查询以修剪
空格?
I imported records into a table, later found out that many of them had
trailing spaces in one of the fields. If I''d caught it sooner, I could have trimmed the spaces before the import.
This wouldn''t work (nothing changed):
UPDATE tblManuals SET tblManuals.PARTNUM = Trim([partnum]);
Would someone please tell me how to do an update query that will trim the spaces?
>
" Randy Harris" < RA *** @ SpamFree.com>在留言中写道
news:rs ********************** @ newssvr28.news.prodi gy.com ...
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:rs**********************@newssvr28.news.prodi gy.com...
PC数据表 <无**** @ nospam.spam>在消息中写道
新闻:b0 ***************** @ newsread3.news.atl.earthl ink.net ...
"PC Datasheet" <no****@nospam.spam> wrote in message
news:b0*****************@newsread3.news.atl.earthl ink.net...
Randy ,
在查询中创建一个新字段并输入以下表达式:
MyUpdateField:Trim([partnum])
然后将查询更改为更新查询在PartNum字段中输入
Randy,
Create a new field in your query and enter this expression:
MyUpdateField:Trim([partnum])
Then change the query to an Update Query and enter this expression where it says
更新到的表达式:
MyUpDateField
Update To in the PartNum field:
MyUpDateField
完美。我应该想到这一点。谢谢!
Perfect. Should have thought of that myself. Thanks!
好吧,我说得太早了。我还有问题。尽管Trim函数在A2K查询网格中工作,但它看起来并不像
。没错,他们只是
不要修剪空间。我尝试了MyUpdateField:Trim([partnum])作为
更新查询,MakeTable查询和Select查询。修剪简单
不起作用。令人惊讶。
Well, I spoke a bit too soon. I still have a problem. It doesn''t look as
though the Trim functions work in the A2K query grid. No error, they just
don''t trim the spaces. I tried the MyUpdateField:Trim([partnum]) as an
Update query, a MakeTable query and as a Select query. Trim just plain
doesn''t work. Surprising.
PC数据表
您的资源以获取Access,Excel和Word应用程序的帮助
re ****** @ pcdatasheet.com
www.pcdatasheet.com
" Randy Harris" < RA *** @ SpamFree.com>在消息中写道
新闻:aU *************** @ newssvr31.news.prodigy.com。 ..
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:aU***************@newssvr31.news.prodigy.com. ..
我将记录导入表中,后来发现其中许多记录在其中一个字段中有尾随空格。如果我早点抓住它,我
I imported records into a table, later found out that many of them had
trailing spaces in one of the fields. If I''d caught it sooner, I
可以在导入之前修剪空格。
这不会工作(没有改变):
UPDATE tblManuals SET tblManuals.PARTNUM = Trim([partnum]);
有人请告诉我如何进行修剪空间的更新查询?
could have trimmed the spaces before the import.
This wouldn''t work (nothing changed):
UPDATE tblManuals SET tblManuals.PARTNUM = Trim([partnum]);
Would someone please tell me how to do an update query that will trim the spaces?
>
这篇关于更新查询帮助的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!