On Mar 20, 4:01 pm, "Bob Bedford" <b...@bedford.com> wrote:
> > Not easy to tell if we don't know what data is in he tables.
>
> I can't export datas as they are confidential.
> anyway the result are strange when I group by a field like it doesn't take
> all results.
> Is the problem from "having" ?

Why not present some dummy data (5 - 10 rows, say) together with the
results you'd expect from that data. Then we'd have a chance, (but
don't make it too easy!)