Newbie, problem with breaks in group whe trying to summarize

V

verci

I'm runnig Access XP, I've created a report with this underlaying query:

SELECT FacturaDetalle.FacturaID, Factura.NumFactura, Factura.FechFactura,
Factura.Nombre, Factura.Retencion, FacturaDetalle.Importe, Factura.Cancelada
FROM Factura INNER JOIN FacturaDetalle ON Factura.FacturaID =
FacturaDetalle.FacturaID
WHERE (((Factura.FechFactura) Between [Fecha Inicial:] And [Fecha Final:]));

Factura is the main form and FacturaDetalle is a
child subform for the details of the invoice.
The translation would be Factura = Invoice, Fecha Inicial = Beginning Date,
Fecha Final =
Ending Date.

Now I've group order my report using the following values in the sorting and
grouping window, Field -> NumFactura, Sort Order->Ascending, Group
header->yes, GroupFooter->No, GroupOn-> Each value, Group Interval->1,
Keeptogether->No.

On the reports design view I've placed the fields on the groups header
section, now my problem is that I can't do a running sum of the filds, so I
can display the grand total of each field and the end of the report, I've
tried adding the groups footer section and putting all the fields grand
total, but so far no success, any help would be greatly appreciated.

Best Regards
 
Top