首頁>Club>

access設定公式？

11
回覆列表
  • 1 # 張張張張先生吖

    ublic Function 公式計算(欄位一, 欄位二, 欄位三, 公式) Dim stemp For N = 1 To Len(公式) If Mid(公式, N, 1) = "A" Then stemp = stemp & 欄位一 ElseIf Mid(公式, N, 1) = "B" Then

  • 2 # 滴逃逃

    有點沒看懂，不過在access裡可以這麼用的

    SELECT iif(Format(time,"mm") in ("01","02","03"),"1季度",

    iif(Format(time,"mm") in ("04","05","06"),"2季度",

    iif(Format(time,"mm") in ("07","08","09"),"3季度",

    iif(Format(time,"mm") in ("10","11","12"),"4季度")))) AS 表示式1

    FROM 表1;

    表名就不說了，time是我測試用的欄位，你給換成你的月份

  • ∧ 中秋節和大豐收的關聯？
  • ∨ 秋季來臨，職場女性應該搭配怎樣的衣服用於應對早晚溫差？