Problem with a report

[Rossella]

I've got a query that gives as a result all the fields I need for my
report.
I need them to be shown in this way..

a b c d e (the headings of the the first 5 fields)

the fields


f g h i j(the headings of the other 5 fields)

the fields


then the sum of the fields e and j


is is possible.?How
Thanks in advance
Rossella

 

[Guest]

Please post the SQL of the query. If this happens to be a crosstab query,
check into the Column Headings property of the query.

 

[Rossella]

SELECT Right$([Agenzia],4) AS Codice_Agenzia, Agenzie.Agenzia,
[Agenzie.Codice_Agenzia] & "-" & [Agenzie.Agenzia] AS Codice_report,
Contributipermese.Tipo, Contributipermese.Modalità,
Sum(Contributipermese.Importo) AS SommaDiImporto,
Contributipermese.Periodo,
Contributipermese.Data_erogazione_contributo, IncassiPeriodo.Periodo,
Sum(IncassiPeriodo.Acquisto) AS SommaDiAcquisto,
Sum(IncassiPeriodo.Incasso) AS SommaDiIncasso,
Sum(IncassiPeriodo.Somma) AS SommaDiSomma,
IncassiPeriodo.Data_Erogazione_Provvigione
FROM Agenzie INNER JOIN (IncassiPeriodo LEFT JOIN Contributipermese ON
IncassiPeriodo.[Codice Agenzia] = Contributipermese.Codice_Agenzia) ON
Agenzie.Codice_Agenzia = IncassiPeriodo.[Codice Agenzia]
GROUP BY Right$([Agenzia],4), Agenzie.Agenzia, [Agenzie.Codice_Agenzia]
& "-" & [Agenzie.Agenzia], Contributipermese.Tipo,
Contributipermese.Modalità, Contributipermese.Periodo,
Contributipermese.Data_erogazione_contributo, IncassiPeriodo.Periodo,
IncassiPeriodo.Data_Erogazione_Provvigione;


it's a query that it's the join of 2 queries

 

[Guest]

Hi,

Even after seeing the SQL, I don't understand the question. Could you show
some example data?