"SELECT * FROM FeeTrans where FeeTrans.rec_date = #11/25/2016#"
i want to fetch the records with exact this date but no records is coming
i have tried "<>" symbols also but it fetches other date also
my rec date's data is in date/time(mm/dd/yyyy)
Sounds like your recorded dates contain time as well. Try this:
"SELECT * FROM FeeTrans WHERE Fix(FeeTrans.rec_date) = #11/25/2016#"
Or (faster if many records):
"SELECT * FROM FeeTrans WHERE FeeTrans.rec_date Between #11/25/2016# And #11/25/2016 23:59:59#"