Hi, I am having a strange problem. I have a small query with 6 money collection dates. I want to rank them, by counting the number of date values that are lower than each record's value. (I later want to use the rank in another function)
CountLowerValues: DCount("*";"dd_collectiondates";"[dtl_collectiondate] <= #" & [dtl_collectiondate] & "#")
values of [dtl_collectiondate] are 1-apr-2014, 1-may-2014, 1-jul-2014, ... The function returns 0 (zero) for each record, whereas it should be returning 1,2,3, etc
What am I doing wrong?
Thanks