My date format is 12/5/2008,Error Type: Microsoft JET Database Engine (0×80040E07) Data type mismatch in crite?

Error Type:
Microsoft JET Database Engine (0×80040E07)
Data type mismatch in criteria expression.

Try this out:
Create the test table:
create table newTable(name text(50), dob date)
Insert some values:
insert into newTable values(’Deni’, ‘14/02/1983′)
insert into newTable values(’Naufal’, ‘26/12/2004′)
create a query, go to SQL View and paste this:
select [...]