That query works fine at SQL, and when I say it works fine I mean its brings me only one distinct vlaue for that date I provide.For a given date that column has same vlaue for all records I want to retrive that value for that date.
The query can't be worng as it works fine at SQL. I was thinking if DISTINCT clause is restricted in POST QUERY trigger in Forms. Why won't it work in forms while it works in SQL?

Please let me know ASAP