Append query--it wants to add 200 records from a table with only 40! 1

[gusbrunston]

:-0

I've made an append query following the help instructions in Access2000. The table I'm appending from has 40 records. I'm warned before running the query that it will add 200 rows--Do I want to continue? Of course not!

I followed directions carefully--
No autonumbers are involved.

Any ideas what I've done wrong? Thanks for your help now and in all the ages past...


Gus Brunston
An old PICKer
padregus@home.com

 

[Smitty020]

make sure you check the properties of the query

"unique records" should be set to "yes"

hth,
Smitty

 

[gusbrunston]

Oh, Smitty!
Thank you for your quick and correct response--I must confess it's the first time I knew queries had properties! Now I'll go nuts looking at all my queries and "properterizing" them!
:~/
Gus Brunston
An old PICKer
padregus@home.com

 

[pjm]

It sounds like you've missed a join somewhere. Are you selecting from two tables, one with 40 rows and the other with 5 rows??