Access查询计算报错：条件表达式中数据类型不匹配

我是Access新手，目前碰到一个看似简单但解决不了的问题，求帮忙。

我的表中有一个**数字（双精度）**类型的字段PERMITTIVITY，想要在表中或新建查询里创建一个新字段，表达式为：
Log([PERMITTIVITY])*0.092376679+0.003073477

同时我需要通过查询的“总计”行，按时间和地点对该新字段进行Avg（平均值）分组统计，但操作时总是出现“条件表达式中数据类型不匹配”“类型不匹配”等错误。

以下是我的查询SQL代码：

SELECT ZONE.COMPOSITION, SENSOR_ZONE.ZONE, SENSOR_ZONE.TREATMENT, SOIL_WATER_CONTENT.MEASURE, SOIL_WATER_CONTENT.DATES, Avg(SOIL_WATER_CONTENT.VALUE_RAW) AS AvgOfVALUE_RAW, Avg(SOIL_WATER_CONTENT.VALUE_RAW_FILTERED) AS AvgOfVALUE_RAW_FILTERED, Avg(SOIL_WATER_CONTENT.PERMITTIVITY) AS AvgOfPERMITTIVITY, Avg(SOIL_WATER_CONTENT.WATER_CONTENT_Jonard) AS AvgOfWATER_CONTENT_Jonard, Avg(SOIL_WATER_CONTENT.WATER_CONTENT_Jacobsen) AS AvgOfWATER_CONTENT_Jacobsen, Avg(Log([PERMITTIVITY])*0.092376679+0.003073477) AS WATER_CONTENT_GuiTil, First(SENSOR.SENSOR) AS FirstOfSENSOR, Avg(METEO.TempAir) AS AvgOfTempAir, Avg(METEO.TempForest) AS AvgOfTempForest, Avg(METEO.Radiation) AS AvgOfRadiation, Avg(METEO.WindDir) AS AvgOfWindDir, Avg(METEO.RelHum) AS AvgOfRelHum, Avg(METEO.TempSoil) AS AvgOfTempSoil, Sum(METEO.Rain) AS SumOfRain, Avg(METEO.WindSpeed) AS AvgOfWindSpeed

FROM 
[ZONE] INNER JOIN ((SENSOR_ZONE INNER JOIN SENSOR ON (SENSOR_ZONE.N_SENSOR = SENSOR.N_SENSOR) AND (SENSOR_ZONE.MEASURE = SENSOR.MEASURE)) INNER JOIN (METEO INNER JOIN SOIL_WATER_CONTENT ON (METEO.Years = SOIL_WATER_CONTENT.Years) AND (METEO.Months = SOIL_WATER_CONTENT.Months) AND (METEO.Days = SOIL_WATER_CONTENT.Days) AND (METEO.Hours = SOIL_WATER_CONTENT.Hourss)) ON (SENSOR.N_SENSOR = SOIL_WATER_CONTENT.N_SENSOR) AND (SENSOR.MEASURE = SOIL_WATER_CONTENT.MEASURE)) ON (ZONE.TREATMENT = SENSOR_ZONE.TREATMENT) AND (ZONE.ZONE = SENSOR_ZONE.ZONE)

GROUP BY 
ZONE.COMPOSITION, SENSOR_ZONE.ZONE, SENSOR_ZONE.TREATMENT, SOIL_WATER_CONTENT.MEASURE, SOIL_WATER_CONTENT.DATES;

我已经试过以下方法，但都没解决问题：

• 在表中添加新计算字段，无法将其转换为数字类型使用，报错“类型不匹配”；
• 在查询中添加字段，表达式为WATER_CONTENT_GuiTil: Avg(Log([PERMITTIVITY])*0,092376679+0,003073477)，但Avg部分无法正常工作，报错“条件表达式中数据类型不匹配”；
• 将表达式Log([PERMITTIVITY])*0,092376679+0,003073477写入条件行，报错“不是聚合函数的一部分”。

内容的提问来源于stack exchange，提问作者Félix Guillaume