S sbaud2003 Member Local time Tomorrow, 03:55 Joined Apr 5, 2020 Messages 184 Feb 22, 2024 #1 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
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 Active member Local time Tomorrow, 00:25 Joined Jul 19, 2022 Messages 188 Feb 22, 2024 #2 Is the number always 7 positions?
E ebs17 Well-known member Local time Tomorrow, 00:25 Joined Feb 7, 2020 Messages 2,212 Feb 22, 2024 #3 Numeric field - do you know addition? Code: UPDATE TableX SET AC_NO = AC_NO + 10000000
C CJ_London Super Moderator Staff member Local time Today, 23:25 Joined Feb 19, 2013 Messages 17,406 Feb 22, 2024 #4 Should be + 90000000
E ebs17 Well-known member Local time Tomorrow, 00:25 Joined Feb 7, 2020 Messages 2,212 Feb 22, 2024 #5 That was a breaking point for our own thinking. Yep, someone knows addition.
S sbaud2003 Member Local time Tomorrow, 03:55 Joined Apr 5, 2020 Messages 184 Feb 22, 2024 #6 XPS35 said: Is the number always 7 positions? Click to expand... YES
S sbaud2003 Member Local time Tomorrow, 03:55 Joined Apr 5, 2020 Messages 184 Feb 22, 2024 #7 CJ_London said: Should be + 90000000 Click to expand... Thanks always, love this Forum
S sbaud2003 Member Local time Tomorrow, 03:55 Joined Apr 5, 2020 Messages 184 Feb 22, 2024 #8 ebs17 said: That was a breaking point for our own thinking. Yep, someone knows addition. Click to expand... Thanks always, love this Forum ebs17 said: Numeric field - do you know addition? Code: UPDATE TableX SET AC_NO = AC_NO + 10000000 Click to expand... Thanks always, love this Forum
ebs17 said: That was a breaking point for our own thinking. Yep, someone knows addition. Click to expand... Thanks always, love this Forum ebs17 said: Numeric field - do you know addition? Code: UPDATE TableX SET AC_NO = AC_NO + 10000000 Click to expand... Thanks always, love this Forum
