Do I use an update or append query

R

RonK

I have a table that contains item numbers and descriptions for products we
sell.
Since new items are being generated daily I need a way to add new ones in
before using this table to generate reports. Whats the difference between the
two queries?
 
R

RonK

Why when I use an append query do I get a message that I am about append
(Example 12856 rows.) when I know that the new items added could only be
10-20 records at the most?
 
J

John Vinson

Why when I use an append query do I get a message that I am about append
(Example 12856 rows.) when I know that the new items added could only be
10-20 records at the most?
Click to expand...

Presumably because you've made a mistake in setting up the append
query. Perhaps you could post the SQL of the query and indicate why
you expect that number of rows.

One common error is to include the target table (into which the data
will be appended) in the query. You should base the append query on
the "source" table - with its 10-20 rows selected; the target table is
only used in the INTO clause of the SQL.

John W. Vinson[MVP]
 
Top