Query Not Updating All Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

There's a database - I have to fix. (I didn't create it. And from here it
feeds into another database.) I ran a query to see if it's hitting all the
records that don't have a null in the "Model" field. It's bypassing some
records with info in that field. Here's the query

UPDATE IP_Vehicle SET IP_Vehicle.Model = (IP_Vehicle.Model & "'")
WHERE ((IP_Vehicle.Model) IS NOT NULL);

Again I only put an ' in to see if it hit all the model fields that have
text in them. But it bypassed a couple of sets of records. And each set has
the same model name.

When I do an UPDATE IP_Vehicle SET IP_Vehicle.Model = (IP_Vehicle.Model &
"'"); - it updates every record.

Another person suggested running a Trim function on the model field but that
didn't help.

I also tried a query to check for Zero Length String - but it only pulled up
the empty fields.


Any ideas?

Thanks
Jess
 
Jess

If you haven't already, consider creating a SELECT query to identify the
records you want. When that's working correctly, convert it to your update
query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top