It will delete all the products which have some ID *other* than zero.<BR><BR>But why would you have any products that *do* have an ID of zero?<BR><BR>I think that will likely simply delete *ALL* your records.<BR><BR>Which you could do with just<BR> DELETE FROM Products<BR>with no WHERE clause.<BR><BR>If you want to delete only those with a specific date, then use the date in the query:<BR> DELETE FROM Products WHERE yourDateField = '06.05.2003'<BR><BR>If this is an Access DB, then you *MUST* use either USA date format or ISO format. I suggest ISO:<BR> DELETE FROM Products WHERE yourDateField = #2003-05-06#<BR><BR>
now you lost me..<BR>If I want to delete all the values that have anything in EndDate i type? The reason i want to delete JUST the field EndDate and nothing else is that this is to be used in a new way and i need to get rid of all values in EndDate, but not in StartDate and the other rows in the same table.
I was off by a second only because i was going by memory of ther exact seconds. I realized after i posted and saw the actual seconds.<BR><BR>Actually though i am proud of myself for thinking up there with you. I just wish i had *1/19th* of the knowledge that you have.<BR><BR>btw, i am brain dead but what style grin is *s.e*? LOL