If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I import data from one table into another?
Hi All
I have two tables - tbltaxes and tblvoters. The tables are structured the following way Tbltaxes Field Description Location Address of the house OldValue Old Value of the house OldTax Old Tax of House NewValue New value of House New Tax New Tax of House Percent Percent increase/Decrease Tblvoters Field Description FName First Name LName Last Name Address Address of House Party Party affiliation The tblVoters will have more records than tblTaxes since each record is a voter (an address could have more than one voter) and include apartments. tblTaxes only include house. I want to create a query or table that will add PERCENT from tbltaxes to all the houses that are in tblvoter. I am not too sure how to go about it. Any advice would be greatly appreciated. Many thanks Mo |
#2
|
|||
|
|||
It will probably not do all as most people do not enter their addresses
exactly the same everytime - such as 1020 30ST - 1020 30 St. - 1020 30th Street - etc. But yoou need to add a Percent field to your Tblvoters table. Create an update query using both tables joining the Location to Address. In the Update To of the grid column for Tblvoters Percent put -- [tbltaxes].[Percent] "Mo Man" wrote: Hi All I have two tables - tbltaxes and tblvoters. The tables are structured the following way Tbltaxes Field Description Location Address of the house OldValue Old Value of the house OldTax Old Tax of House NewValue New value of House New Tax New Tax of House Percent Percent increase/Decrease Tblvoters Field Description FName First Name LName Last Name Address Address of House Party Party affiliation The tblVoters will have more records than tblTaxes since each record is a voter (an address could have more than one voter) and include apartments. tblTaxes only include house. I want to create a query or table that will add PERCENT from tbltaxes to all the houses that are in tblvoter. I am not too sure how to go about it. Any advice would be greatly appreciated. Many thanks Mo |
#3
|
|||
|
|||
Hi,
You add the column for every records, just supply a default NULL value for it. Next, update the column you just added: Make a new query, bring the two tables, define the join (I assume you know how), change the query type from SELECT to UPDATE (from the menu or the toolbar), update the column you added with the column of the table having already that data. Hoping it may help, Vanderghast, Access MVP "Mo Man" wrote in message oups.com... Hi All I have two tables - tbltaxes and tblvoters. The tables are structured the following way Tbltaxes Field Description Location Address of the house OldValue Old Value of the house OldTax Old Tax of House NewValue New value of House New Tax New Tax of House Percent Percent increase/Decrease Tblvoters Field Description FName First Name LName Last Name Address Address of House Party Party affiliation The tblVoters will have more records than tblTaxes since each record is a voter (an address could have more than one voter) and include apartments. tblTaxes only include house. I want to create a query or table that will add PERCENT from tbltaxes to all the houses that are in tblvoter. I am not too sure how to go about it. Any advice would be greatly appreciated. Many thanks Mo |
#4
|
|||
|
|||
Vanderghast
Worked like a charm. Many thanks!! Mo |
#5
|
|||
|
|||
Karl
Many thanks Mo |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with relationship plase | Rock | Database Design | 5 | July 4th, 2005 03:54 AM |
Unable to have multiple queries feeding a single report | PZ Straube | Setting Up & Running Reports | 15 | June 15th, 2005 08:16 AM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
Update - If statement | Dan @BCBS | Running & Setting Up Queries | 13 | December 14th, 2004 06:02 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |