changing of a report

[dragon]

which Formula do I have to choose to build up following Report from following table

table
cust__G/F____cost
a______g______10
b______f______20
c______g______10
c______f______30


Report

cust___G____F
a_____10____0
b______0___20
c_____10___30

Would be great if you could help me.

Cheers Kai
This message was edited by dragon on 2002-12-17 03:05

 

[Russell Hauf]

How about a crosstab query? My fields are named CUST, GF, and COST, respectively. My table name is tbl121702 -- change these names to yours.

TRANSFORM Nz(Sum([COST]),0) AS [TOTAL COST]
SELECT tbl121702.Cust
FROM tbl121702
GROUP BY tbl121702.Cust
PIVOT tbl121702.GF;

Hope this helps,

Russell