s*******n
发帖数: 15 | 1 我在ACCESS里面新建一个query时，需要将table里的一个field劈开成两列。具体就是将
形如last name,first name的内容分成last name一列，first name一列。在design view
里面的criteria里该用什么function？Left? Right? Len?
Thanks a lot!! | a*******t
发帖数: 891 | 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*******n
发帖数: 15 | 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
:
: 将
|
|
