I have an SQL statement to a table that deletes records based on a timestamp.

I've tried using the BeforeDelete and AfterDelete events to increment a counter variable, but it never hits these events.  However, the SQL executes with no issue.

How can I determine the number of records deleted (or the records that will be deleted)?

I know I can probably use a select and get a recordcount beforehand, but was just wondering if there's a way I wouldn't have to execute 2 statements, as well as provide a progress bar to indicate where it is in the delete process.

Sorry if this is a stupid question - I've always used tables in the past, but need to use SQL due to the timestamp being variable.

I found it!  Please disregard...