Excel & Access Formula Tips - Thu, Jun 16, 2022
Some useful Formula Tips of Excel and Access
excel
=IF(SUMPRODUCT(N(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))>10000)),1,0)
access
=DLookUp("[stockName]","[stockList]","[stockCode]='" & [Forms]![录入交易]![stockCode] & "'")