海狸先生，ceiling函数的问题！！！

access10000

我用ceiling ,可一运行就说未定义啊，怎么办？这是这个查询的代码：

SELECT Call.ID, Call.CallerName, Call.CallerIP, Call.CalledNumber, Call.BeginTime, Call.EndTime, Call.TimeLen, ceiling([timelen]/6,1) AS feepoint, [feepoint]*[monovalent] AS amounts

FROM Call

WHERE (((Call.CallerName) Like "*" & [请输入你想要查询的的callername] & "*") AND ((Call.CalledNumber) Like "*" & [请输入你想要查询的的callernumber] & "*"));

海狸先生

请参考这里http://www.office-cn.net/forum.php?mod=viewthread&tid=25984

access10000

非常感谢，我的问题已解决。

leolong

呵呵