Hi All,
This forum did solve 50% of my problem; hopefully I can solve the rest with your help.
I created a crosstab query that counts the number of records, and distribute the results, based on a time stamp, over the 4 quarters. When there is now result for i.e. Q2, the Nz function display's a "0". Perfect so far..!
But... when there are no results at all, the result of the crosstab query is completely empty. I want four "0"'s in that case.
Please advice! This is my code:
Code:
TRANSFORM Nz(Count(Q_LicensesSeatsLargeAccounts.Quantity),0) AS CountOfQuantity
SELECT Q_LicensesSeatsLargeAccounts.Reseller
FROM Q_LicensesSeatsLargeAccounts
WHERE ((Q_LicensesSeatsLargeAccounts.Reseller)=[Forms]![F_RBSC_Selection]![cboReseller])
GROUP BY Q_LicensesSeatsLargeAccounts.Reseller, Q_LicensesSeatsLargeAccounts.Reseller
PIVOT "Q" & DatePart("q",[OrderDate]) In ("Q1","Q2","Q3","Q4");
With regards,
Eric
Crosstab query with no results
