I written a query where i pull debtor number and and amont of sales from a
period of specified time and all works well.
It's is returning a line for every debtor transaction where i want the total
for all transaction over the year.
So 1 line for the debtor with the total transaction for the year.

SELECT dih_dbtno, dbt_name, dih_type, dih_date, dih_eom ,sum(dil_ordertotal)
from xxxxxx_xxxxxx_xxxxxxx_,xxxxxx_xxxxxxx_xxxx_xxxx,xx xxxx_xxxxxx_xxxx
where dih_link = dil_dihlink
and dih_dbtno = dbt_no
And dih_eom '14'
and dih_eom < '27'
and dih_type= '73'
Group By dih_dbtno , dbt_name, dih_type, dih_date, dih_eom