--- In firebird-support@yahoogroups.com, John vd Waeter <john@...>
wrote:

John,

Results for 1.1.2007-31.1.2007 are OK.
Results for 1.2.2007-28.2.2007 are OK.
Results for 1.3.2007-24.3.2007 are OK.
Results for 1.1.2007-28.2.2007 are OK.
Results for 1.1.2007-09.3.2007 are OK.
Results for 1.1.2007-10.3.2007 are NOT OK.
Results for 2.1.2007-10.3.2007 are OK.
Results for 4.1.2007-11.3.2007 are NOT OK.
etc...

I tried to debug query, and when it brakes, it always brakes on the
same GROUP BY value, and it is value which is always with bigest
result.

Therefore, the dates are OK (I tHink), it is question how to reduce
number of decimals in result set(again my opinion).

I am looking for more answers.

Regards,

Zile

> ok.. if you comment out the sum and the group by, is the query

result as

> expected?
> (just to rule out a possible problem with the date-parameters)
>