A query deleting multiple records

[atrium]

I Have a query that deletes multiple records from a table. The record entries to be deleted is a variable. I want to be able to report to the user the number of records deleted
Can I get access to the total deleted, total searched etc
Appreciate any help

 

[pbaldy]

If you're using a database object you can use RecordsAffected. If not, probably counting records before and after. Showing your code would help.