Delete query

[Forza MIlan]

Hi, can i make a "delete query", and when i start this query window appear
and type there "start date" then in another window "end date". And all the
records from this period to be deleted?? For example i want to delete all
rows which includes dates from 01.11.2007 till 04.11.2007.
Hope you understand my question)

 

[Brendan Reynolds]

Hi, can i make a "delete query", and when i start this query window appear
and type there "start date" then in another window "end date". And all the
records from this period to be deleted?? For example i want to delete all
rows which includes dates from 01.11.2007 till 04.11.2007.
Hope you understand my question)

Here's an example using the "Orders" table from Microsoft's "Northwind"
sample database ...

DELETE Orders.*
FROM Orders
WHERE (((Orders.[Order Date]) Between [start date] And [end date]));

 

[Forza MIlan]

Thanks, it is working wneh i type in criteria onlt this
Between [start date] And [end date]