Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

yui asked in 電腦與網際網路軟體 · 1 decade ago

access運算式?

做了個簡易的物料管理,公式一直寫錯,不曉得是那邊有問題,有誰能救救我~~

資料表:

物料-物料編號、品名、類別、期初庫存、庫存數、安全庫存、停產、備註、圖片

存貨交易-交易識別碼、領用日期、領用人、領用數量、補貨日期、補貨數量

表單:詳細資料開頭物料的欄位,但不包含期初庫存的欄位, 下面加子表單為存貨交易

表單首裡設一個

-總庫存:=Sum([產品]![期初庫存]-[領用數量]+[補貨數量])

子表單內的詳細資料-補貨數量:=Sum([產品]![庫存數量]-[領用數量])

所以物料的庫存數量:=[記錄].[Form]![總庫存]

我這樣寫是不是不對?

1 Answer

Rating
  • 1 decade ago
    Favorite Answer

    你表單名稱及欄位所在位置沒有表達的很清楚耶~如[產品]及[紀錄]是主表單或子表單...等等,可以直接寄檔案過來參考!希望對你有幫助!

    2009-09-11 13:02:00 補充:

    請寄到teamwork@eztakeeasy.com

Still have questions? Get your answers by asking now.