Delete record using SQL but shows deleted record only.

[Jenny]

Hi ,

I have a basic question about SQL.
I need to delete a record from customer list and the Syntax is as
below:

DELETE tblcustomer.* FROM tblcustomer
WHERE (((tblcustomer.Customer_Name)='ics'));

However, the result shows only one Deleted record "ICS".
Do I miss anything?
Thanks

Jenny

 

[Douglas J. Steele]

What were you expecting? Do you have other customer named ics?

Did you perhaps want to delete rows for any customer whose name started with
ics? If so, try:

DELETE tblcustomer.* FROM tblcustomer
WHERE (((tblcustomer.Customer_Name) LIKE 'ics*'));

If you wanted to delete rows for any customer who had ics anywhere in their
name, try:

DELETE tblcustomer.* FROM tblcustomer
WHERE (((tblcustomer.Customer_Name) LIKE '*ics*'));

If you're using ADO, and not DAO, replace the asterisks with percent signs:

DELETE tblcustomer.* FROM tblcustomer
WHERE (((tblcustomer.Customer_Name) LIKE 'ics%'));

or

DELETE tblcustomer.* FROM tblcustomer
WHERE (((tblcustomer.Customer_Name) LIKE '%ics%'));

 

[Guest]

Hi Jenny,

It looks right to me. Are you sure that you had more than one record with
the CustomerName of ics in the table to start with?


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________