AND Operator in the Query

[drunkenneo]

I am using query

SELECT tblDataentry.*
FROM tblStaffs INNER JOIN tblDataentry ON tblStaffs.SL_No = tblDataentry.staffName
WHERE (((Format([tblDataentry].[createdDate],"dd/mm/yyyy"))=Format(#6/10/2014#,"dd/mm/yyyy")) AND ((tblStaffs.SL_No)=31))


ORDER BY tblDataentry.createdDate DESC;

which is not showing any results, where as if i replace "AND" to "OR" or remove one condition it works, Please tell me how to make it work?

[pbaldy]

Looks okay offhand. Are you sure there's a record meeting both criteria? If you take out the SL_No criteria, does one of the records returned have 31 in that field?