LUIS FREUND
asked on
Expression in a query design from an Excel formula
So I have this formula in a excel and was wondering if this could be on my access query design mode as an expression.
The tHREE fields are "NOT ISSUED" and "QTY ON HAND" and "PART NO"
The excel formula is as such: =IF(E2=E3,"",H2-SUMIF(E2:E 2,E2,G2:G2 ))
Where column E is "[PART NO], column H is [QTY ON HAND], and column G is [NOT ISSUED]
The tHREE fields are "NOT ISSUED" and "QTY ON HAND" and "PART NO"
The excel formula is as such: =IF(E2=E3,"",H2-SUMIF(E2:E
Where column E is "[PART NO], column H is [QTY ON HAND], and column G is [NOT ISSUED]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The excel sheet attached on column K "STOCK QTY" are the values I wish to incorporate on qry_M_DEM on the attached database.
C--Users-lfreund-Documents-EE-STK-Q.xlsx
C--Users-lfreund-Documents-STOCK.accdb