Delete Query in design view. The field in the panel gives two options . FROM and WHERE. Explain?

[fen38]

So in this panel




It gives the other option on the drop down - FROM

However it automatically goes back to WHERE

I understand the SQL code for this. But why has MS put this in as it serves no purpose

[ranman256]

this query is wrong,
bring down the * into the grid
FIELD should be: *
DELETE should be FROM

[fen38]

Yeah but adding a * will delete the whole record on the table

If i add a Criteria then I gen a error message

I just want to know what to know when creating a simple delete query

It gives the option (FROM to WHERE)

BUT !

MS ACCESS always defaults to where

[ranman256]

thats what a delete query does. it deletes the whole record.

or do you want to erase the field contents?....then that is an update query.