Help any idea
this is my query but on the reports,
i try to sum() one column and no works
i use the grouping on the report
Select invoicehd.invnum,invoicehd.fdate,caja.paytype,caja.amountpay,caja.amountchange,caja.stationid,invoicehd.custid,caja.userid,invoicehd.total
From caja inner join invoicehd on caja.cntid=invoicehd.payid where sdate >= '08-01-2017' and sdate <= '08-30-2017' and caja.stationid='01'