delete all data in a row with condition on the row

S

sverre

Hi

I have tried a sql that looks like this:

DELETE [Bokföringen mxg].TRADE_DATE, *
FROM [Bokföringen mxg]
WHERE ((([Bokföringen mxg].TRADE_DATE)=#5/16/2008#));

I want to achieve that access deletes all rows where condition on trade_date
is 16th may 2008.

The query does not work correct.

Could someone help me.

Sverre
 
B

Brendan Reynolds

sverre said:
Hi

I have tried a sql that looks like this:

DELETE [Bokföringen mxg].TRADE_DATE, *
FROM [Bokföringen mxg]
WHERE ((([Bokföringen mxg].TRADE_DATE)=#5/16/2008#));

I want to achieve that access deletes all rows where condition on
trade_date
is 16th may 2008.

The query does not work correct.

Could someone help me.

Sverre
Click to expand...


Try ....

DELETE * FROM YourTableName WHERE YourFieldName = YourCriteria

Using your table and field names ...

DELETE *
FROM [Bokföringen mxg]
WHERE ((([Bokföringen mxg].TRADE_DATE)=#5/16/2008#));

That is to say, there's no need to specify a field or fields in the DELETE
clause.
 
Top