Update Query clearing previous results

[tarheelkate]

I have 7500 records in my table, which has many columns, one of them being
"CallTotal". The primary key is the AiringID.

I created an update query that is intended to update the CallTotal. To do
this, i linked up an excel spreadsheet to my database. I copy and paste info
to the excel sheet twice a day. I then created an update query that matches
the AiringID and fills in the current CallTotal.

The problem is, I'm never updating all 7500 records, it's usually only 100
or so at a time. The update query successfully updates the 100 records, but
is clearing out all the CallTotals for the remaining 7400 records.

What did I do wrong?

Thanks for your help!

 

[Rick Brandt]

I have 7500 records in my table, which has many columns, one of them
being "CallTotal". The primary key is the AiringID.

I created an update query that is intended to update the CallTotal.
To do this, i linked up an excel spreadsheet to my database. I copy
and paste info to the excel sheet twice a day. I then created an
update query that matches the AiringID and fills in the current
CallTotal.

The problem is, I'm never updating all 7500 records, it's usually
only 100 or so at a time. The update query successfully updates the
100 records, but is clearing out all the CallTotals for the remaining
7400 records.

What did I do wrong?

Did you use an outer join in the update query? Post the SQL.

 

[John W. Vinson]

What did I do wrong?

I don't know. What did you do?

We can't see your computer nor do we know how you defined the query. Please
post the SQL.

John W. Vinson [MVP]

 

[Michel Walsh]

Did you use a TOP 100 while you should have use TOP 100 PERCENT (may
happen, as example, if you intend to update *through a view*, in MS SQL
Server)?


Vanderghast, Access MVP