Any Access gurus out there?

PSUBride2Be

I am stumped and need some help!I'm trying to write a query that will update all fields in a row if one specific field in that row is already empty.  The condition I'm using is:(fieldname) is null or like ""While it worked for the majority of items in my table, there were a few that weren't updated, even though the field is blank.Any suggestions on any workarounds?  TIA!

d78

I know a little about Access, but wouldn't call myself a guru...do those fields that didn't get updated maybe have a space in them? I haven't done much with update queries, but just wrote a query the other day that didn't work and had to totally delete it & start from scratch, which seemed to work. Since your data is in the table, deleting the query may not hurt anything. I HATE Access with a passion! But I've gotten used to it from needing it every day. GL!!

d78

Oh, do you write your queries in SQL? I know programming languages can be a b!tch. If you use the builder instead, it's much easier (but I'm guessing you may know that).

PSUBride2Be

I did not write this one in SQL - just using the query builder.  I checked, and there are no spaces in the fields.  It's just like Access is seeing them as being populated, but really they are not!  It's driving me crazy!

d78

Wow, I'm not sure what that is...there are some access forums I sometimes go to when I'm stumped. I used to have them written down, but lost them so anytime I get stumped now I try a google search. Maybe "Microsoft Access update query problems"? Good luck with it! I totally & completely understand your frustration! I've been there!