Bs_SQL Function features:
- Make report (unlimited column and rows) with only one function
- The result of this functions is text -> Helf reduce capacity, speed up workbooks
- In BS_SQL function can combine with many supporting funtions such as: Sum, AVG, Count, Max, Min, VTC, recno, top, distinct....
- Users can creat BS_SQL function by dragging and dropping
- User able to use both of VBA of Excel and use programming library of A-Tools
- And more advance in BS_SQL function otpions: Connect to other databases, use BS_SQL function online, Auto or not creat headers, auto or not creat names, auto or not insert rows....
BS_SQL Structure:
=BS_SQL("Select List_fields from Name_Data where Conditional Group by List_fields_groups Having List_Number_fields Order by List_Number_Fields","Optional")
List_Fields: All fields (*), list_fields are seperated by comma (,)
Optional: HR=NO; INSERT=YES; DBKEY=NAME_DBKEY; SERVERSOURCE=YES....
0 Comment:
Đăng nhận xét