Update Query Help

[Andre Da Costa [Extended64]]

Hello,
I am trying to create a Delete Query to delete records in a Microsoft Access
table created after February 28th 2006.
The date format is: mm/dd/yy

Thank you, any help appreciated.

--
Andre
Extended64 | http://www.extended64.com
Blog | http://www.extended64.com/blogs/andre
http://spaces.msn.com/members/adacosta
FAQ for MS AntiSpy http://www.geocities.com/marfer_mvp/FAQ_MSantispy.htm

 

[Ken Snell \(MVP\)]

What have you tried so far? A generic query SQL statement is this:

DELETE * FROM Tablename
WHERE DateFieldName > #2/28/2006#;

 

[Andre Da Costa [Extended64]]

Thanks Ken, I figured it out, I used > Datevalue ("1-Mar-06") as the string,
I actually wanted all records after March 1st, to be deleted. Thanks for
taking the time to help.
--
--
Andre
Windows Connect | http://www.windowsconnected.com
Extended64 | http://www.extended64.com
Blog | http://www.extended64.com/blogs/andre
http://spaces.msn.com/members/adacosta