SQL code to delete one specific record from a table?

{Access}
DELETE * FROM YourTable WHERE ID IN (1, 2)

Never heard of a 'dual primary key'.  Can you give me a 'for example'?

I don't know what you Access Gurus call it, but i call it a dual primary key, where you have 2 fields as the primary key, so you can have repeats in a single field, but no duplicate combinations.  See example db if you want an example
Dual-Primary-Key-Example.mdb

Worked like a charm; thanks for the help.

Thanks again