i created a microsoft report that can be filtered by whatever i write in a text box
my database is access database and my table contain a column that contains only one of two values yes or no wich are text not checkbox
the table name is investinside and the column that contains the yes or no name is state
i want to add to the page footer the following to the page footer :
1- a box that counts the number of records found after filtering 2- a box that counts the number of how many yes in the column state 3- a box that counts the number of how many no in the column state 4- a box counts the percentage of of yes based on the number of the records that found after filter
how can i do that ?
thank you