Access 2k3 Compile error. in query expression Date()
I'm getting a compile error on this query: (using Access 2003)
INSERT INTO tblESavingsArchive ( CostCenter, MTDBalances, YTDBalances, DateTimeStamp )
SELECT tblESavings.CostCenter, tblESavings.MTDBalances, tblESavings.YTDBalances, Date() AS Expr1
I've checked to see in the VB window if any of the dependancies are missing, and they seem to be ok.
If I replace the "Date() AS Expr1" portion with something like "01/01/2006" it works fine.
Any help would be greatly appreciated.
It works... sometimes... for no reason whatsoever it works now. Then a few minutes later it stopped working, only to start working again. Very weird....
Last edited by yallmf; 07-27-2006 at 10:25 AM.