Office中国论坛/Access中国论坛

标题: help!!!how to divide one column to two columns in Access table [打印本页]

作者: test999    时间: 2003-1-5 12:34
标题: help!!!how to divide one column to two columns in Access table
Could you tell me how to divide one column to two columns in Access table? For example, one column includes Company and Date of product received. I want to divide the column to one column for Company and another one for Date. But I don't know how to do it. There are huge records, it will make me crazy to divide it by mannul.

Thank you your guys' help.

Jane

作者: cattjiu    时间: 2003-1-5 17:34
You can use Query to divide it. You should first get the format by which to separate it. For example, AAAA01/02/02 is Company name and date in [fielda]. Then you can use Company: =left([fielda],4) to get the company name, and DateIssue:mid([fielda],5,8) for date. Pls. give me a sample record.


[此贴子已经被cattjiu于2003-1-5 9:34:01编辑过]






欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/) Powered by Discuz! X3.3