|
|
I need to add data to a table from another table how do I acheive
--
kh
|
|
0
|
|
|
|
Reply
|
 Utf
|
2/5/2010 6:12:01 PM |
|
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.
"khussey" <khussey@discussions.microsoft.com> wrote in message
news:AD14BFC9-A98B-4FFD-A31F-E722F1F0D666@microsoft.com...
>
> --
> kh
|
|
|
0
|
|
|
|
Reply
|
Jeff
|
2/5/2010 7:32:26 PM
|
|
An Append or Update query - see online help
--
HTH,
Bob Barrows
|
|
|
0
|
|
|
|
Reply
|
Bob
|
2/5/2010 7:59:26 PM
|
|
On Fri, 5 Feb 2010 10:12:01 -0800, khussey <khussey@discussions.microsoft.com>
wrote:
< 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.
--
John W. Vinson [MVP]
|
|
|
0
|
|
|
|
Reply
|
John
|
2/5/2010 9:59:51 PM
|
|
|
3 Replies
160 Views
(page loaded in 0.074 seconds)
Similiar Articles: Update Data in one table based on matching field in another table ...... would like to add to table 2, but the data ... to be 55.00 I do not need to do this with a Payment field already in table 2. ... table where the data is in another table ... Put data from 2 tables on one form - microsoft.public.access ...... need to display all the data from a record so that we can make changes to it. But there are some fields that are just references to another table ... add data to two tables ... import data from access table into a existing table - microsoft ...... has the data I need, so the mapping is not a one to one, The SQL table many more columns so I need to do ... Import Data From Another ... Data wizard. If you need to add ... View Pivot Table Source data as a Data Table - microsoft.public ...... need to add some columns to the original data table and ... second table ... In XL 2003 you could select another pivot table as source data for a second pivot table. How do ... Adding new records to a table in VB code - microsoft.public.access ...... that loads several arrays with fields that I need to add to a table. When I go to another ... trying to add data from a form to a table - microsoft.public ... a few versions ... Is there a quick way to create an Update query? - microsoft.public ...I have a table with about 30 fields. I need to update it with data from another table. I understand how to create an update query but is there a quicker way of adding ... unlink a table without deleting it - microsoft.public.access ...... that you need to break the link in order to add the necessary data > to the table. What are you *actually* proposing to do? ... deleting child tables. Is there another ... insert record from list box to table do i need to use vba ...... field in a table ... box is another table containing ContactName and ContactID, then all you need to do is ... ... you could use this string to add data to your table. ... need Automatically adding data between two dates. - microsoft.public ...... date(s) that I need to look at. I have the data entered in a table ... There's no need to add any data that ... VBA-- add one year , base on the date of another textbox ... MS Access Copy record to another table based on a form input ...... from one table into another table ... give me VBA code to do it, please highlight where I need to make changes (ie rename tables ... How to Add Data to a Table Via a Form in ... Adding Table Data Regions (Visual Studio Report Designer)... data-bound report items within a table data region, including another ... When designing a report, you add a table data ... Now I need to add a grouping footer line for ... How to Add Data to a Microsoft Access Table | eHow.comThings You'll Need ... Adding data to a table can often seem like a tricky task, but... How to Use an Access Form to ... How to Add a Data Table to an Excel Chart | eHow.comHow to Add a Data Table to an Excel Chart. A data table can easily be added to a chart in ... you choose the option to "Show Data Table with Legend Keys," there is no need ... Automatically Add New Data to an Excel Pivot TableNext time you add data to your table, just refresh your pivot! No formulas to learn :) ... source data is Table1, Table2, etc. As Ankit pointed out, you need only to refresh data Transferring Data from One Table to Another — DatabaseJournal.com... of methods to transfer data from one table to another. ... Not only do DBAs need to know how to transfer data between two tables on the same ... Add databasejournal.com to ... 6/28/2012 4:07:13 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
16 followers. 