I have two a column which contains columns one is Dept and other is Region values as 'hr','manager','ceo','sales','accounts','crest','audit','payments','insurance','finance' and some blank values in my access table. I need to create a report by considering this column so I need to see the report like below by taking the FILTER by Region as I have 9 Regions
Header 1
Header 2
Header 3
Header 4
Dept
In
Out
current
hr
manager
ceo
sales
accounts
crest
audit
payments
insurance
finance
I need to get count of hr,manager,ceo and so on in the fileds In, Out,Current by considering the same Dept column to get In,Out, Current.
Could anyone help me how to write the script for this.
