LS

The statement below returns 20 records

select id_medewerker, datum,
min(aanvang) as begin, max(einde) as einde,
max(einde) - min(aanvang) as werktijd
from registraties
where id_medewerker = '20003'
and datum between date'2004-07-01' and date'2005-04-01'
group by id_medewerker, datum

If I set maxrowcount in edbmngr to 10 I except that the result would be the
first 10 records. It only gives 4 records as result.

Regards, Harry

Harry,

<< If I set maxrowcount in edbmngr to 10 I except that the result would be
the first 10 records. It only gives 4 records as result. >>

MaxRowCount under EDB works the same as with DBISAM - it only limits the
number of rows input into an aggregated query.  It doesn't affect the number
of rows output from an aggregated query.

--
Tim Young
Elevate Software
www.elevatesoft.com