问一个小问题！ - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

问一个小问题！

问一个小问题！# Database - 数据库

s*n2005-07-27 07:07

1 楼

我在ACCESS里面新建一个query时，需要将table里的一个field劈开成两列。具体就是将
形如last name,first name的内容分成last name一列，first name一列。在design view
里面的criteria里该用什么function？Left? Right? Len?
Thanks a lot!!

a*t2005-07-27 07:07

2 楼

SELECT
Left([field1], inStr([field1], ",") - 1 ) AS lastName,
Right([field1], inStr([field1], ",") ) AS firstName
FROM Table1;
then I switched to design view and those showed up in the "field" boxes:
lastName: Left([field1],InStr([field1],",")-1)
firstName: Right([field1],InStr([field1],","))
http://office.microsoft.com/en-us/assistance/HA010547271033.aspx

将
view

【在 s*******n 的大作中提到】

: 我在ACCESS里面新建一个query时，需要将table里的一个field劈开成两列。具体就是将
: 形如last name,first name的内容分成last name一列，first name一列。在design view
: 里面的criteria里该用什么function？Left? Right? Len?
: Thanks a lot!!

s*n2005-07-27 07:07

3 楼

Thanks a lot!

【在 a*******t 的大作中提到】

: SELECT
: Left([field1], inStr([field1], ",") - 1 ) AS lastName,
: Right([field1], inStr([field1], ",") ) AS firstName
: FROM Table1;
: then I switched to design view and those showed up in the "field" boxes:
: lastName: Left([field1],InStr([field1],",")-1)
: firstName: Right([field1],InStr([field1],","))
: http://office.microsoft.com/en-us/assistance/HA010547271033.aspx
:
: 将