Append Query Duplicating Data

  • Thread starter Thread starter CQ
  • Start date Start date
C

CQ

This is a new one to me. I have a table with two fields,
an ID field that is "AutoNumber" and a date field that
is "date/time". I have an append query that has only one
function. It appends the date field with the "NOW()"
expression. That's it.
Here is the problem. When it runs it always doubles the
number of entries. In other words, I run it once, it
puts in one entry (which it should). I run it again and
it puts in two entries, run it a third time and it puts
in four entries, then 8, then 16, then 32, etc. The data
it puts in the Date field is correct - and identical.
Thanks for your time in advance.
 
This is a new one to me. I have a table with two fields,
an ID field that is "AutoNumber" and a date field that
is "date/time". I have an append query that has only one
function. It appends the date field with the "NOW()"
expression. That's it.
Here is the problem. When it runs it always doubles the
number of entries. In other words, I run it once, it
puts in one entry (which it should). I run it again and
it puts in two entries, run it a third time and it puts
in four entries, then 8, then 16, then 32, etc. The data
it puts in the Date field is correct - and identical.
Thanks for your time in advance.
Click to expand...

It sounds like your Append query includes the target table. It
shouldn't. Could you post the SQL view of the query?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Not much too hit but here goes:

INSERT INTO tbl_mcr2Dev_Profile_Log ( [TimeStamp] )
SELECT Now() AS Expr1
FROM tbl_mcr2Dev_Profile_Log;
 
Thanks John. I took out the table and I believe that it
is working now. Sometimes it is the "simple" things.
:-) Thanks so much!
 
Back
Top