I'm not a VB programmer.. Tinker here and there.. I know this is a very easy question..

In a Microsoft Access Database I have a Table called "inventory".
In "inventory" i have a field called "location" that I want to go to null after I update another field. I know I can make a expression to do this, but not sure how to do it.

Thanks in advance,

Michael

update inventory set location=NULL where x=y

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.