Changing a duplicate select query into a delete query, help!!

[JC]

Hello,

I am trying to change a select, find duplicates, query into a delete
query. I want to get rid of the records in the main table
"tblHurnsHistor y." I changed the Find Duplicates query to a Delete
query. I then received an input box looking for criteria that
states,"

Enter parameter value
qryHurnsHistory .Grads_creditsE arned

Then it deletes 0 records. I need it to delete the 48 that the Find
Duplicates query returned.

I am a little rusty at SQL, can you help me so the following SQL
deletes the records returned by the FindDuplicates query.
DELETE HHDelete.SyStud entID, HHDelete.Grads_ creditsEarned, HHDelete.ID,
HHDelete.Studen tName, HHDelete.SSN, HHDelete.adTrmC ode,
HHDelete.GPA_cr editsEarned, HHDelete.Status Desc, HHDelete.Status Date,
HHDelete.LDA, HHDelete.ProgVe rsCode, HHDelete.TermCo de,
HHDelete.term_c redits, HHDelete.TotalC rd, HHDelete.credit sAttempt,
HHDelete.GPA, HHDelete.Credit sRemaining, HHDelete.SumOfR eceived,
HHDelete.SumOfR efunded, HHDelete.FundSo urce
FROM tblHurnsHistory AS HHDelete
WHERE (((HHDelete.SyS tudentID) In (SELECT [SyStudentID] FROM
[qryHurnsHistory] As Tmp GROUP BY [SyStudentID],[Grads_creditsEa rned]
HAVING Count(*)>1 And [Grads_creditsEa rned] =
[qryHurnsHistory].[Grads_creditsEa rned])));
Thanks in advance,

Justin

[breadon]

I suspect you need to rewrite your query eliminating all group by
clauses, including any in qryHurnsHistory . Alas you do not state your
table's primary key. In the following example, the primary key is
my_table.my_id1 . My_table.my_cou nt and my_table.my_id2 are the
duplicated fields.

DELETE my_table.*
FROM my_table
WHERE ((((select count(*) from my_table b where b.my_id2 =
my_table.my_id2 and b.my_count = my_table.my_cou nt and my_table.my_id >
b.my_id))>0));

Above uses a subquery and is probably the style of query that you need.
Try help on 'subquery' and 'table alias' if you are new to the
technique.

Good Luck.
Breadon