Search results
-
L
Crosstab query for 7 days in future
I have a cross tab query set up to display the quantity of products ordered each date. I want the query to dynamically show only the future 7 days as columns. So the query would return: ProductName, 10/06/2010, 11/06/2010, 12/06/2010. TestProduct, 0, 10, 25 I've tried using the PIVOT IN command...