Distinct Date Totals 1

[netrusher]

Below is the code I currently have that select distinct
Dates from my table based on a date range. There is a total
of 171 unique dates in this query. My question is how can
I create a query that will just give me the total of 171
instead of showing each date?

SELECT DISTINCT [All gages].[DATE DUE]
FROM [All gages]
WHERE ((([All gages].[DATE DUE]) Between #3/1/2008# And #3/31/2009#))
ORDER BY [All gages].[DATE DUE];

 

[PHV]

SELECT Count(*) AS CountOfDistinctDates
FROM (
SELECT DISTINCT [DATE DUE] FROM [All gages]
WHERE [DATE DUE]) Between #2008-03-01# And #2009-03-31#
) AS C

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[netrusher]

thanks PH,

I am getting a

Syntax error in FROM clause error

 

[PHV]

Sorry for the typo:
SELECT Count(*) AS CountOfDistinctDates
FROM (
SELECT DISTINCT [DATE DUE] FROM [All gages]
WHERE [DATE DUE] Between #2008-03-01# And #2009-03-31#
) AS C

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[netrusher]

Thanks PH