Time Periods in Crosstab Query 1

[BikeToWork]

I am making a crosstab query based on a fiscal year of invoice amounts in monthly invoice periods. Is there some way to make a crosstab query show periods such as months, even if that period contains no invoice amounts? Currently the query does not display invoice periods as column headers if there is no invoice data for that period. My question is how to make all the months show up as column headers and have zero show up as the amount for months where there is no invoice data. Thanks in advance for any help.

 

[PHV]

Have a look at the IN operator in the PIVOT clause.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[BikeToWork]

Your advice is spot on. Thanks, PHV.