Hi James,

Your message says:

<<I'm trying to modify a DATE field in MS Access with the following SQL
statement:

UPDATE Companies SET Date = #02/03/2001# WHERE ID = 89

It's not working, nor is anything else I've tried. Always get an error.
How do u use the SQL "UPDATE" command to modify a DATE field in Access?>>

Both Date and ID are reserved words place them in brackets.  For example,

UPDATE Table1 SET [Date] = #09/09/1944# WHERE [ID]=3


Rick Dobson
www.programmingmsaccess.com
www.cabinc.net
rickd@c... <mailto:rickd@c...>



-----Original Message-----
Subject: UPDATE Date field in Access
From: "James Duncan" <vbcode@j...>
Date: Sun, 8 Jul 2001 23:18:55
X-Message-Number: 1

Hi,

I'm trying to modify a DATE field in MS Access with the following SQL
statement:

UPDATE Companies SET Date = #02/03/2001# WHERE ID = 89

It's not working, nor is anything else I've tried. Always get an error.
How do u use the SQL "UPDATE" command to modify a DATE field in Access?

Thanks

James