Date() & DateAdd return #Name? in ART2002

M

Mark Watling

I have forms and queries that use the Date() and DateAdd("m",[field],Date()) formulas but these return #Name? when running the database under an Access 2002 Runtime environment. Does anyone know why? Or is there any other way of doing the same thing?
 
G

Graham R Seach

Mark,

If Date() actually returns a date (try it!), then the problem is that you
have mispelled [field], or it doesn't exist. Perhaps in your context, you
need to fully qualify the column - [tblMyTable].[Field].

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html


Mark Watling said:
I have forms and queries that use the Date() and
Click to expand...
DateAdd("m",[field],Date()) formulas but these return #Name? when running
the database under an Access 2002 Runtime environment. Does anyone know
why? Or is there any other way of doing the same thing?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
DATEADD should skip the weekends 3
Using DateAdd and IIF conditions in a Query 2
Date Time Picker (MSComCtl2.DTPicker.2) 1
DateAdd Function for and ENTIRE Month 3
Chg "day" portion of DateAdd Date 3
Date formats using DateAdd - year shows as 4 digits (sometimes) 2
#Name? Error with DateAdd function 7

Top