SQL Delete Query - RecordCount?

[Javawag]

Hi there,

I'm creating a few DELETE queries to remove records in one table which don't have a relation in another table - I used the "Find Unmatched Query" wizard to generate the SQL and this works fine.

What I'd like to do is show a message afterwards to explain how many records have been deleted? I guess I could do it by opening a RecordSet object instead of using straight SQL, but is there an easier way?

Thanks in advance,
- Javawag

 

[raskew]

Try first using the 'Find Unmatched Query' which will display the number of records, then convert to a delete query.

Bob

 

[Javawag]

Try first using the 'Find Unmatched Query' which will display the number of records, then convert to a delete query.

Bob

That's not exactly what I'm after. What I'm trying to do is put a button on a form which, once clicked, deletes unmatched records and then shows a message box, for example "Cleanup complete. 12 records were removed."

Hope this helps,
- Javawag