By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,574 Members | 2,966 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,574 IT Pros & Developers. It's quick & easy.

Create tables Using VBA

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.