How do I import data from one table into another?

[Mo Man]

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

 

[Guest]

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]

 

[Michel Walsh]

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]

Vanderghast

Worked like a charm. Many thanks!!

Mo

 

[Mo Man]

Karl

Many thanks

Mo