I have a Master table which has employees and departments. I want to run Maketable type of query or another solution so it splits the Master table into several tables by department.
Is there any other way, rather creating 20 make-table queries (for 20 departments) and then putting this into a Macro
thanks
help would be appreciated