Using Update/Append not working?

  • Thread starter Thread starter rgrantz
  • Start date Start date
R

rgrantz

I thought I completely remembered how to do this from Access 97, but maybe
they changed stuff, as I'm using 2000 Premium now.

Trying to enter data from a field in one table into a field in another
table, but using criteria.

Example, Table1 has 40 fields, but I only want to copy FieldOneData from
Table1 to Table2's FieldOneData where Table1's FieldTwoData is not null.

I've tried using an Update and Append Query, both of which say I'll be
updating 0 rows.

In the query Builder I try to update (or append) Table2:

FieldOneData TO: [Table1]![FieldOneData]

.... and in criteria I put [Table1]![FieldTwoData] is not null

I tried using the Append and Update methods, and also tried using the "."
instead of the "!" as table/field identifiers.

Oddly, a Make Table query worked, but I'd like to know how to do this
without making a new table, as I will need to insert data eventually, while
for now I am in the testing stage.

Thanks all.
 
Here is a query, made in Northwind, that updates the shipping country, when
null, to the customer's home country field in the customer table.

UPDATE Customers
INNER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID
SET Orders.ShipCountry = [Customers].[Country]
WHERE (((Orders.ShipCountry) Is Null));

Use it as a model for your inner join
 
Back
Top