If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot Query ??
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... |
#2
|
|||
|
|||
Pivot Query ??
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 '================================================= === Devlin wrote: 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... |
Thread Tools | |
Display Modes | |
|
|