By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,403 Members | 891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,403 IT Pros & Developers. It's quick & easy.

Having problems updating one table from another.

P: n/a
Hi All -

I'm new to Google Groups and just a novice user of Access, so please
forgive me if my question is elementary:

I am having a problem using the "update query" for my first time. In
my database, I have two tables. Both of the tables have duplicate
data, though the "Initial Data" table has many more records than the
"Filter Two" table due to a process of elimination that has occurred in
the past week. Both tables have 5 colums of important data. Recently,
the fields for the "Filter Two" table have been updated (with comments,
etc...) and I would like to automatically copy the data permanently
into the "Initial Data" table.

So far so good. I created an "Update Query" and selected the Columns I
would like to update in the "Initial Data" table. Next, in the "Update
to" field I entered: [Table Two].[Comments and Notes] etc for all five
rows. When I try to run the query, Access is asking me "Enter the
parameter value" and then just inputs whatever I type in to the fields
in the "Initial Data" table.

Would someone please suggest what I am doing wrong? Is there an easier
way to input the new data? (its over 1000 entries * 5 rows so i cant /
wont do it manually!)

Many thanks in Advance!

- jb

Mar 6 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Br
be*****@gmail.com wrote:
Hi All -

I'm new to Google Groups and just a novice user of Access, so please
forgive me if my question is elementary:

I am having a problem using the "update query" for my first time. In
my database, I have two tables. Both of the tables have duplicate
data,
Why duplicate data? Sort of defeats the point of a database doesn't it?
though the "Initial Data" table has many more records than the
"Filter Two" table due to a process of elimination that has occurred
in the past week. Both tables have 5 colums of important data.
Recently, the fields for the "Filter Two" table have been updated
(with comments, etc...) and I would like to automatically copy the
data permanently into the "Initial Data" table.
Why not just use one table and put a flag (boolean) field on it to
differentiate the initial/filter records?
So far so good. I created an "Update Query" and selected the Columns
I would like to update in the "Initial Data" table. Next, in the
"Update to" field I entered: [Table Two].[Comments and Notes] etc for
all five rows. When I try to run the query, Access is asking me
"Enter the parameter value" and then just inputs whatever I type in
to the fields in the "Initial Data" table.
You have to include the second table in your query and link it to the first
one.

Show us the SQL of the query.
Would someone please suggest what I am doing wrong? Is there an
easier way to input the new data? (its over 1000 entries * 5 rows so
i cant / wont do it manually!)

Many thanks in Advance!

- jb


--
regards,

Br@dley
Mar 7 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.