select查询运行良好(access 2013)。一旦我将它更改为交叉表,它就会给出错误“条件表达式中的数据类型不匹配”。我使用交叉表值中的vba函数作为表达式。我的表中没有空值,并且尝试使用变量作为我的数据类型。
VBA
enter code here
'assumes that the rate is monthly
Public Function payFrequency(frequency As String, rate As Currency) As Currency
If frequency = "BI-WEEKLY" Then
payFrequency = rate * 12 / 26
Exit Function
ElseIf frequency = "SEMI-MONTHLY" Then
payFrequency = rate * 12 / 24
Exit Function
ElseIf frequency = "MONTHLY" Then
payFrequency = rate
Exit Function
Else
payFrequency = 0
Exit Function
End If
End Function和SQL
TRANSFORM
payfrequency([structurepayrollFrequency],
Max([2015_PREMIUM]-[2015_EMPLOYER_CONTR])) AS 2015_EMPLOYEE_CONTR发布于 2015-10-19 20:25:19
我建议您在查询中构建这个函数,而不是VBA。在任何情况下,这都是我最喜欢的解决方案;来自查询的VBA调用通常效率不高,而且很难解决问题。
https://stackoverflow.com/questions/33222387
复制相似问题