Date() & DateAdd return #Name? in ART2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
Back
Top