Update Query Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andre Da Costa [Extended64] - 25 Mar 2006 23:58 GMT

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.

Signature

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

Reply to this Message

Ken Snell (MVP) - 26 Mar 2006 00:40 GMT

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

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

Signature

Ken Snell
<MS ACCESS MVP>

> 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.

Reply to this Message

Andre Da Costa [Extended64] - 26 Mar 2006 22:25 GMT

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.

Signature

--
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

> What have you tried so far? A generic query SQL statement is this:
>
[quoted text clipped - 7 lines]
>>
>> Thank you, any help appreciated.

Reply to this Message