I need to add data to a table from another table how do I acheive

[khussey]

--
kh

 

[Jeff Boyce]

Why?

Having two copies of the same data exposes your database to integrity
issues.

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Bob Barrows]

An Append or Update query - see online help

 

[John W. Vinson]

< nothing >

It's considered polite to use the big textbox to ask a comprehensible
question, not just use the subject line.

As noted elsethread, this is probably a Bad Idea - relational databases use
the Grandmother's Pantry Principle, "a place - ONE place! - for everything,
everything in its place". Storing the same data in multiple tables risks
anomalies if one or the other table gets edited; you then have "the same" data
actually being different.

That said, an appropriate Query (append or update) could do this. If you would
like help with a query post some more information about your tables and what
you're trying to do.