平時用 MS Access 就用得多, 其中有一個叫 format 既 function 可以將資料用規定特定既格式輸出. 但係有日係 Excel 就唔識用, 仲搞咗好耐. 最後當然俾我搞掂, 就係用 Text() , 例如 =Text(7,”00″) 輸出結果為 07
下次有機會再同各位研究一下.
|
|||||
|
大致上有: /excl, /ro, /user, /pwd, /profile, /compact, /repair, /convert, /x, /cmd, /nostartup, /wrkgrp 同 /runtime. 想知多 d 就 click 入下面條 link 睇睇啦~ http://support.microsoft.com/kb/209207 A hole in Microsoft’s Access database permits hackers to install software on vulnerable systems, the US-CERT team warns. Online criminals are exploiting a flaw in the Microsoft Office Access database to install unauthorized software on computers, the United States Computer Emergency Readiness Team (US-CERT) has warned. In its brief warning, US-CERT offered few [...] 找到一個好似好好既網站, 同大家分享一下: http://www.functionx.com/vbaccess/index.htm 今日係公司諗緊用一個最有效既方法用出生日期去計算年紀. 以下為得出之答案: = Fix(DateDiff(“y”, [Input Date], Now()) / 365.25) 解說: Fix 是只取除數後既整數, 忽略餘數; 因為一年為 365 日, 而每 4 年會多 1 日, 所以平均會多 0.25 日 |
|
||||
|
Copyright © 2010 清心小棧 - All Rights Reserved |
|||||
