Reports: update, import, deleting records.

Hi,

How do I proceed for my problem, database classification, placing game résults.

In this case my database contains from one to fifteen records, rows (with indentification and résults from dogs game)
A new records, data no problem "importing data - add records at the end"

But updating I must work eround, can it be done in one time?

Explanation: offline I workout all the individual résults, with a macro in a spreadsheet, and put all the data from the records and persons that had a possible change on a new sheet.
What can change: Add new record if player do not have fifteen games. Better résults if player has already fifteen games, the worst must be deleted from a specific state he played. Mistake in spelling must be corrected .. I know it is complex, that are rules of the game, there for I work offline.

The import data "add records and replace if exist" do not do this job write for me.

How do I work now:
Filter on dogname and delete all his rows, that for each dog. Lots of work.
Than import all the new data from my worked out sheet at once. Works fine.

Question: How can I delete all records of all dogsname I specify at once ?

 

Frank