Dcount Problem

[drunkenneo]

I have a statement

int1 = DCount("*", "tblDataentry", "((([tblDataentry].[dateofTravel])=#" & d & "#) AND (([tblDataentry].[flightNo])= " & Chr(34) & e & Chr(34) & ") AND (([tblDataentry].[membershipNo])= " & Chr(34) & l & Chr(34) & ") AND (([tblDataentry].[origin])= " & f & ") AND (([tblDataentry].[dest])= " & g & "))")

I have a table where i have to check dupliates is already yhere or not, but even after the same data i couldnot able to get count of int1 other than 0. Please help , Thanks in Advance

[drunkenneo]

I have a statement

int1 = DCount("*", "tblDataentry", "((([tblDataentry].[dateofTravel])=#" & d & "#) AND (([tblDataentry].[flightNo])= " & Chr(34) & e & Chr(34) & ") AND (([tblDataentry].[membershipNo])= " & Chr(34) & l & Chr(34) & ") AND (([tblDataentry].[origin])= " & f & ") AND (([tblDataentry].[dest])= " & g & "))")

I have a table where i have to check dupliates is already yhere or not, but even after the same data i couldnot able to get count of int1 other than 0. Please help , Thanks in Advance

It is solved by taking care of format date.