Solved UPDATE QUERY (1 Viewer)

[sbaud2003]

I want to update all records in a tbl of a numeric field AC_NO with AC_NO preceeded by 9 for example if Account No is 8337453 it should be updated to 98337453. What will be the vba code for query

 

[XPS35]

Is the number always 7 positions?

 

[ebs17]

Numeric field - do you know addition?

UPDATE TableX SET AC_NO = AC_NO + 10000000

 

[CJ_London]

Should be + 90000000

 

[ebs17]

That was a breaking point for our own thinking.
Yep, someone knows addition.

 

[sbaud2003]

Is the number always 7 positions?

YES

 

[sbaud2003]

Should be + 90000000

Thanks always, love this Forum

 

[sbaud2003]

That was a breaking point for our own thinking.
Yep, someone knows addition.

Thanks always, love this Forum

Numeric field - do you know addition?

UPDATE TableX SET AC_NO = AC_NO + 10000000

Thanks always, love this Forum