How to count number of days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
SELECT Count(*) As CountOfDates FROM
(SELECT DISTINCT MyDate FROM tblSomeTable)

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