更新某一列的值,取其相反数。
字符串转double: CDbl(“字段名”);
例子:
UPDATE data SET s2 =CDbl(s2)*(-1)
WHERE DataTime < #2019/01/06 0:30:00#;
更新某一列的值,取其相反数。
字符串转double: CDbl(“字段名”);
例子:
UPDATE data SET s2 =CDbl(s2)*(-1)
WHERE DataTime < #2019/01/06 0:30:00#;
转载于:https://www.cnblogs.com/lypstudy/p/11550634.html