help rewriting this query

[icemonster]

hello. basically what i am trying to do here is that if the date is not equal to current date, reset count or something to that effect.

 (Select count(*) from [qry_01] where [id_employee] = a.[id_employee] and [datex]+[timex] <= a.[datex]+a.[timex])

 

[pr2-eugin]

Hello icemonster.. I am sorry but I do not follow you.. You cannot "reset the count", it is a function's return value that is obtained by the condition you have provided.. In simple words, with some examples could you explain what is that you are doing?