Query input must contain at least one table or query

[rinu911]

hi all

I am tring to insert a values to a table by checking if the value is there in the table already

but it gives me this error

"Query input must contain at least one table or query"

here is my query

insert into details values('6025','12/21/2009',' 9:07:57 AM','HP.Color_LaserJet_555_PCL_6','2','Document 3, dotNET Size in bytes: 192548; pages printed: 2')
where details.Date1 not in ( select Date1 from details where details.Date1 = '12/21/2009') AND details.Time not in ( select Time from details where details.Time = ' 9:07:57 AM')

[debasisdas]

You can't use a WHERE clause in an INSERT statement.

[rinu911]

hi thanks for the replay

is there any other alterative for this

[missinglinq]

DLookup() is normally used to check for values in a query or table. You can use an If...Then construct to see if the record already exists before trying to create the new record. DLookup() can have a two part Criteria.

Welcome to Bytes!

Linq ;0)>