macman
04-30-2009, 06:08 AM
Hi ,
I have a quary for taking the training course and the number of runs for that
course. I wanted to take the 'Number of days' and 'In Which Month'
this course is taught on. the table will look similar to the prototype below
Course Code - Run_Number - Start Date - End Date
101 1 01/01/2009 01/01/2009
101 2 02/01/2009 02/01/2009
101 2 03/01/2009 03/01/2009
101 3 04/01/2009 04/01/2009
102 1 31/01/2009 31/01/2009
102 2 01/02/2009 01/02/2009
102 2 02/02/2009 02/02/2009
how to count the number of days like the below
Course = 102
Count of Run Number = 2
No of Days = 1 day in january and 2 days in February
Thanking you inadvance
macman
I have a quary for taking the training course and the number of runs for that
course. I wanted to take the 'Number of days' and 'In Which Month'
this course is taught on. the table will look similar to the prototype below
Course Code - Run_Number - Start Date - End Date
101 1 01/01/2009 01/01/2009
101 2 02/01/2009 02/01/2009
101 2 03/01/2009 03/01/2009
101 3 04/01/2009 04/01/2009
102 1 31/01/2009 31/01/2009
102 2 01/02/2009 01/02/2009
102 2 02/02/2009 02/02/2009
how to count the number of days like the below
Course = 102
Count of Run Number = 2
No of Days = 1 day in january and 2 days in February
Thanking you inadvance
macman