Pivot Query ??

[Devlin]

I am using a pivot query to display totals by year and transaction type.

Example:

2000 2001 2002
TransType1 3,000 2,000
TransType2 1,000
TransType3 5,000

What I want to do is see zeros where no value occurs.

Example:

2000 2001 2002
TransType1 3,000 0 2,000
TransType2 0 1,000 0
TransType3 0 0 5,000

Can this be done?

Thanks...

 

[John Spencer]

Post your SQL statement. (HINT: Select View: SQL from the menu while in
design view)

I think you will probably need to change the Transform statement to
something like:

TRANSFORM CDbl(NZ(SUM(FieldX),0)) as LineTotal
SELECT ...


'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================