Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
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
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Export Access Query to Excel ShanVel Queries 7 11-18-2009 09:42 AM
Query Runs. Report based on query crashes Access john471 General 0 02-22-2006 10:35 PM
query for last order date MarySan1 Queries 9 10-26-2005 06:27 AM
[SOLVED] syntax error in date in query expression Gusman_nz Modules & VBA 0 09-22-2005 05:08 PM
'Todays' Date in Query Felony Queries 2 02-03-2005 03:27 PM




All times are GMT -8. The time now is 02:27 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World