View Single Post
Old 07-27-2006, 06:03 AM   #1
yallmf
Registered User
 
Join Date: Jul 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
yallmf is on a distinguished road
Access 2k3 Compile error. in query expression Date()

Hello all,

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
FROM tblESavings;

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.

Thanks!

edit:

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.
yallmf is offline   Reply With Quote