i am wondering how i can count number of record based on selected items in a list box . suppose the below table and in the list box i have items (ZONE,SUB_CON_COMPANY,SITE_TYPE) , now based on items selected from list box i want to know number sites
In a textbox try expression =Count(ZONE) . Then keep on playing with selection and see the output in the textbox. In fact, if you can use Count(anyfield ), where anyfield has no NULL values.
Actually , in other word i want to know how can i implement the SQL logic( count(*)) with dynamic Group by ,the group by fields should Add based on listbox selected items , so if only Zone selected the group by only include Zone and if Zone and sub_con_company selected then group by should include zone and sub_con_company and so on ..
