A Allie Joined Mar 6, 2007 Messages 1 Reaction score 0 Mar 6, 2007 #1 Hi How would I modify the following query UPDATE Spend SET Spend.Conference = "Meetings" WHERE (((Spend.Account)=541080123)); to not update if the field is already populated? Ideally I'd like to get a list of the records not updated as well?
Hi How would I modify the following query UPDATE Spend SET Spend.Conference = "Meetings" WHERE (((Spend.Account)=541080123)); to not update if the field is already populated? Ideally I'd like to get a list of the records not updated as well?
