Ben_Entrew
Registered User.
- Local time
- Today, 10:08
- Joined
- Dec 3, 2013
- Messages
- 177
Hi all,
I got a simple problem here.
How can I change a number column in a three digit percent one?
Tried the following, however it just deletes the content of the column:
Does anyone have a clue?
Thanks in advance.
Regards,
Ben
I got a simple problem here.
How can I change a number column in a three digit percent one?
Tried the following, however it just deletes the content of the column:
Code:
Public Sub TEST()
Dim a11 As Double
Dim year As Integer
DoCmd.SetWarnings False
DoCmd.RunSQL "UPDATE DEPT_FILES SET [AAA 2014 % TNS] = FormatPercent([AAA 2013 % TNS],3)"
DoCmd.SetWarnings True
Does anyone have a clue?
Thanks in advance.
Regards,
Ben