Sort Query by Date???

  • Thread starter Ben Wallace \(3\)
  • Start date
B

Ben Wallace \(3\)

I have a cross-tab Qry, that's takes in a two parameter date range [start
Date] & [end date]. My question is.....does anyone know how to have the
cross-tab columns be return in ascending date order. If the date range is
from 10/2/2004 to 10/12/2004, then I would like the column to read
10/2/2004, 10/3/2004, 10/4/2004 etc.... Below is my Qry text if that helps.

PARAMETERS [Start Date] DateTime, [End Date] DateTime;
TRANSFORM Sum(QryBaseTransactionData.Amts) AS SumOfAmt
SELECT QryBaseTransactionData.pkTransTypeID AS TransType,
QryBaseTransactionData.TransTypeDefinition, Sum(QryBaseTransactionData.Amts)
AS [Total Of Amt]
FROM QryBaseTransactionData
WHERE (((QryBaseTransactionData.Date) Between [Start Date] And [End Date]))
GROUP BY QryBaseTransactionData.pkTransTypeID,
QryBaseTransactionData.TransTypeDefinition
PIVOT Format([Date],"Short Date");


Thanks.
 
Top