Hi there, need help in converting the excel fomulas to ms access.
=IF(C2<=0,IF(SUM(B$2:B3)<F$2,0,SUM(B:B)-F$2),"")
below is the data from query1 and query2
QUERY1
COLUMN ACOLUMN B COLUMN C
DATEPurchasedAvailable
cell2 September 30, 201050 0
cell3 December 31, 2010100 172*
cell4 January 01, 201110
cell5 January 02, 201150
cell6 January 03, 201150
cell7 January 04, 201112
QUERY2
DATE Consumed
23-Sep 100
Once the data was been updated in query2, Available will update and returns 0 if was been diispense
or theresany other way to compute this using SQL or code builder?...
please advise.. many thanks!