Delete Records according to One Criteria in one Field
 

Hi

Recording a Macro while filtering according to a criteria then deleting
those records remaining will not work as the reference of the records
deleted in the macro recorded could be different the next time round.

Can anyone help me with the VB command that would delete all records
that are equal to a criteria where the field name , in my case
"FinancialCategory" , is equal to 50.

Many Thanks


Roger Ramseier

Delete Records according to One Criteria in one Field
 

See this page for a possible solution
http://www.rondebruin.nl/delete.htm

Post back if you need more help


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Roger The Rabbit" wrote in message ups.com...
Hi

Recording a Macro while filtering according to a criteria then deleting
those records remaining will not work as the reference of the records
deleted in the macro recorded could be different the next time round.

Can anyone help me with the VB command that would delete all records
that are equal to a criteria where the field name , in my case
"FinancialCategory" , is equal to 50.

Many Thanks


Roger Ramseier