Exists in Access

[roma_victa]

hi all,

I am developing an application in vb and access

my sql query in access please have a look.

str = "insert into details values('" & username & "','" & CDate(date1) & "','" & time & "','" & PrinterName & "','" & noofpages & "','" & _ Message.ToString & "') WHERE not exists (select * from details where Date1 = " & CDate(date1) & " And Time = '" & time & "')"I was trying to check the database before adding the records

For some reason its not working

Query input must contain at least one table or query

Is exists allowed in access or is there any other keywords in access

is there any other alternative for this