Automate make table query with different criterias
Posted on 2011-02-14
I have a make make query which I want to cut in four different ways using an equal to criteria based on one field. So for example, fieldname1 equals 'Finance' then the second cut would be 'HR'. Rather than create four different make table queries I would just like to have a macro that can run through the 4 criterias and make the four cuts into another database (into tables).
I need to run the macro off a query because that in itself is made of 2 joined tables.
A pseudo code example would be nice.