Advance functions

Beside BS_SQL function, Add-In A-Tools supply more advance functions. These functions base on BS_SQL function so you can use all of supporting functions, advance options.
Advance functions in Add-In A-Tools including: BS_DLOOKUP, BS_DSUM, BS_DAVG, BS_DCOUNT, BS_DMAX, BS_DMIN, BS_DVAR, BS_DFUNC, BS_TABLE
Note: All of Parameters of these functions ar put in quotation marks ("")
BS_DLOOKUP(Expr, Table_Source, Search_Condition[,Option]). The result of this function can be one value or array of value
BS_DSUM(Expr, Table_Source[, Search_Condition],[Option]). The result of this function is one valuve. Search_Condition can be one or many table in databases
BS_DCOUNT(Expr, Table_Source[, Search_Condition],[Option])
BS_DMAX(Expr, Table_Source[, Search_Condition],[Option])
BS_DMIN(Expr, Table_Source[, Search_Condition],[Option])
BS_DAVG(Expr, Table_Source[, Search_Condition],[Option])
BS_DVAR(Expr, Table_Source[, Search_Condition],[Option])
BS_DFUNC(FuncName, Expr, Table_Source[, Search_Condition],[Option]). FuncName is one of list following functions: SUM, COUNT, AVG, MIN, MAX, VAR