Update column in Access using query in VB.Net

Question

I need to update a column by adding a value in Access:

update table1 set column1 = column1+value

In the above, if column1 is null, then the table is not updated.

I need a function like in SQL Server:

update table1 set column1 = isnull(column1,0) + value

Fionnuala · Accepted Answer · 2012-01-04 10:32:20Z

1

You do not give a data type for column1. The string concatenator is & not +, so consider:

UPDATE Table1  
SET Table1.AText = [AText] & "A", 
    Table1.ANumber = Nz([ANumber],0)+1;

In both these examples, the column (field) will be updated even if it is null.

answered Jan 4, 2012 at 10:32

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

cs95 · Accepted Answer · 2019-07-04 03:34:23Z

0

i think there is no option for it in query if you are using Access as database (Backend)

cs95

406k106 gold badges745 silver badges798 bronze badges

answered Jan 4, 2012 at 8:35

Nighil

4,1277 gold badges34 silver badges58 bronze badges