查询里提取出来的文本型怎么做相加?

需要用到类型转换函数

CInt、CLng、CDbl、CCur

用VAL也行

SELECT hmfx.haoma, Right(haoma,1) AS gewei, Left(Right(haoma,3),1) AS shiwei, Left(Right(haoma,5),1) AS baiwei, (val([baiwei])+val([shiwei])+val([gewei])) AS bsghe
FROM hmfx;

SELECT hmfx.haoma, Right(haoma,1) AS gewei, Left(Right(haoma,3),1) AS shiwei, Left(Right(haoma,5),1) AS baiwei, (clng([baiwei])+clng([shiwei])+clng([gewei])) AS bsghe
FROM hmfx;

.....