How to count number of days

X

xpetex

How can I count the number of days there are in a query if the results are
bringing up varying dats and results that are the same, so for example..

10/02/2005
10/02/2005
11/02/2005
11/02/2005
15/02/2005
15/02/2005
15/02/2005
15/02/2005
16/02/2005

I want the result from the equation to be how many individual days there are
there, so in this case the numerical output would be 4, as there are 4
seperate days. I need this to work out wages based on day rate rather than an
hourly rate.
 
G

Graham R Seach

SELECT Count(*) As CountOfDates FROM
(SELECT DISTINCT MyDate FROM tblSomeTable)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Top