Is it true that with this query and the results below not returning just one row would be becuase my date column lenghts are different lengths, i.e. some are 8 char's long and some dates are 9 char's long?????


Code:
SELECT DISTINCT [Budget].[Hotel], "Janurary" AS DrptMonth, [Budget].[Account], [Budget].[Description], [Budget].[Amount], Sum([Budget].[Amount]) AS SumOfAmount
FROM Budget
WHERE ((([Budget].[Account])="10-41220")) And month([budget].[drptdate])=1 And [budget].[hotel]="CQSC"
GROUP BY  [Budget].[Hotel], [Budget].[Account], [Budget].[Description], [Budget].[Amount];

Code:
Hotel	DrptMonth	Account	Description	Amount	SumOfAmount
CQSC	Janurary	10-41220	Business Travel Club	-820	-820
CQSC	Janurary	10-41220	Business Travel Club	-492	-492
CQSC	Janurary	10-41220	Business Travel Club	-410	-820
CQSC	Janurary	10-41220	Business Travel Club	-246	-246
CQSC	Janurary	10-41220	Business Travel Club	-164	-1312
CQSC	Janurary	10-41220	Business Travel Club	-82	-1476