sql statement to find if records were not added

[tomClark]

I have an sql statement in access to find records > 1



3 fields ID, name, and Date.
I use this statement to find if duplicate records were added.
SELECT ID,COUNT(name)AS CNT
FROM Table1
WHERE (((Table1.Date)=[Enter Date]
GROUP BY ID
HAVING COUNT(name)>1;

now I want to find records < 1 ( records not added)
there are 30 records added each week- is there anyway to search and find if any were not entered - without physically looking at report.
thank you

[llkhoutx]

Try

dim rs as recordset
dim SQL as string
sql="SELECT ID, COUNT(name)AS CNT _
      FROM Table1 _
      WHERE (((Table1.Date)=[Enter Date] _
      GROUP BY ID _
      HAVING COUNT(name)<" & 1
set rs=currentdb.openrecordset(SQL,dbopensnapshot)
if rs.recordcount <1 then
  'no records added
  'do something
end if 

[tomClark]

thanks I will try that