Using Count with Delete Query

[taimysho0]

Hello i have a table that looks like this:




i want to create a delete query where it will count rows with the same Channel ID and Due Date, and if the count is > 1, then delete.

the output should be ONE row with ONE channel ID with that particular Due Date. thanks

[aytee111]

You don't seem to care about losing the other data, such as Date Requested?

Make a copy of the table, structure only.
Create an append query that groups on those two fields and append to the new table.
Create an update query to update the rest of the fields, linking both tables with the two fields.