Please provide more information such as the layout of the manager and
other table and the primary keys of the tables.
I don't understand:
"I want to use to split the table up into seperate tables which are
linked to a manager"
"I could use to link the query with but I have not been able to sort
out the linking"
You say "Which are linked" then your say "Not been able to sort out
the linking"
Generally, you can create a query using the two tables, then use this
query as the record source for your make table query. Also, you can use
a Where clause in your make table query for selecting the manager.
Ron
David wrote:
I am hopeing someone can help me with this as I have struggled over the last
few days with it. I have a make table query which I want to use to split the
table up into seperate tables which are linked to a manager. I have a
Manager table which I could use to link the query with but I have not been
able to sort out the linking.
I have been trying to link on the manager and use that field as a
parameter with the table i need to split, but to no avail.
Thanks in advance
Dave