I have created a crosstab query that calculates to total purchases made from a supplier<br><br>Here's the SQL statement:<br><br>TRANSFORM Sum([Supplier Purchases].[PO Total]) AS [SumOfPO Total]<br>SELECT [Supplier Purchases].[Supplier Number]<br>FROM [Supplier Purchases]<br>GROUP BY [Supplier Purchases].[Supplier Number]<br>PIVOT Format([PO Date],"mmm-yyyy" In ("Jan-2000","Feb-2000","Mar-2000","Apr-2000","May-2000","Jun-2000","Jul-2000","Aug-2000","Sep-2000","Oct-2000","Nov-2000","Dec-2000"<br><br>My question is, can the year ("yyyy" automatically roll-over to 2001 on if the [PO Date] is in 2001??????<br><br>Thanks in advance