Hi,

I made a news Archiv und I have a problem with 'Group by' in a SQLquery
what I don't understand is what is going on,
because for some months it works really fine and for other months it
doesn't.
in the months that don't work the following situation happens.
The query gives me only the first dates and supresses the ohters.
If I check the select without 'group by', I get all dates.

I didn't see any differences between the entries in the database
by the months what work and the months that don't work.

I don't know what to do right now, only what I can see right now that
the date and idnumber are not in order.
i think the user, who have the entry rights didn't edit the datas,
they delete them and wrote them new.

but does it really matter, cause the query takes the datas corectly
without 'group by'only the Group by doesn't work.

Beside english is not my motherlanguage I hope you can undertstand my
problem.

thanks alot for any help

bye
Matth