Update Query

[dpaulson]

Is there a way to issue an update query that can do simple arithmetic to a value that is in the database?

For example

strSQL = "UPDATE Table SET Field = Field + 1"


David Paulson

 

[gmmastros]

Yes.

With the example you show, every 'field' value should have 1 added to it. If the value is NULL, it will stay NULL.

As far as I know, that query should work with Access, Microsoft SQL Server, and probably many other databases.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[dpaulson]

Thanks gmmastros

I could swear that I had already tried that, but I just checked in visdata and it does indeed work.

David Paulson