Strange behavior from append query

[twalsh]

I have an append query moving select data from one table to another. It only
appends data that has a yesterday in the "SubmitDate" field. However, if i do
any other day than yesterday, or if i try to append a range of dates. the
data gets appeneded 19 times. is this a common mistake i am making? it seems
like there is something simple i am overlooking...

 

[Jerry Whittle]

Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.

Also moving data from one table to another is usually a bad idea. Could you
explain why you are moving the data?

 

[Jeff Boyce]

"Appending", in and of itself, does not "move data", it copies.

Next, without a look at the SQL statement, and some idea of your data
structure, we can only guess what might be happening.

Finally, if you are "moving select data from one table to another", you
might be "committing spreadsheet" on Access. It is rarely necessary (or
desireable) to move data from one table to another, or to copy data into a
second table.

If you'll describe a bit more about what having that data in "another" table
will allow you to do, folks here might be able to offer approaches that let
you more easily use Access' relationally-oriented features/functions.

Regards

Jeff Boyce
Microsoft Office/Access MVP