追加查询返回消息:“未定义函数”日期"在表达中 [英] Append query returns message: "undefined function "Date" in expression
问题描述
我正在将Access 2000更新为Access 2016. 我的访问2000有一个查询来附加数据,包括两个日期,定义为"Date()"。对于当前日期。 我将数据从一个数据库附加到另一个数据库。  当我在
Access 2016中运行此查询时,它会返回一条消息:"表达式中未定义的函数"Date"。 Access 2016中不支持Access 2000中的Date()函数吗?
I am updating my Access 2000 to Access 2016. My access 2000 has a query to append data including two dates defined as "Date()" for the current date. I am appending data from one data base to another one. When I run this query in Access 2016 it returns a message: " Undefined function 'Date' in expression." Is the Date() function from Access 2000 not supported in Access 2016?
这是SQL:
Here is the SQL:
INSERT INTO费用([地址代码],供应商,[费用代码],Amt,[Inv日期],[输入日期])IN'\\ guy\access\db1.mdb'
SELECT" XSM" AS [Addr Code],"FICAme" AS供应商,"税收" AS [费用代码],[FICAme总计] .SumOfFICAme,日期()AS [Inv日期],日期()AS [输入日期]
FROM [FICAme Total];
谢谢你你的帮助,
Guy
推荐答案
嗨Guy,Date()仍然受支持;但是,由于较新版本的Access导致破坏的引用会破坏一些内部函数。检查您的VBA引用并修复任何缺少的引用。希望它有所帮助......
Hi Guy, Date() is still supported; however, broken references due to newer versions of Access break some internal functions. Check your VBA references and fix any missing ones. Hope it helps...
这篇关于追加查询返回消息:“未定义函数”日期"在表达中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!