Getting total per month

  • Thread starter Thread starter carmen
  • Start date Start date
C

carmen

Hi,
I am trying to generate a query that will give me the total number of
classes completed per month that take longer than 8 hours.
The table i am getting the informationfrom has the following fields ClassID,
DateStarted,DateFinished,Class1,Class2.
The results would look like:
Month Class1 Class2
Jan 5 4
Feb 0 2
Mar 8 6

Note that the date fields are using General Date as the format.

Any help is greatly appreciated.

Thanks
Carmen
 
I guess I don't understand your table. You would have a ClassID suchs as
ECON101, two dates, and then what are the CLASS1 and CLASS2 fields? What
goes there?

I assume when you say "more than eight hours" you mean that the start and
end date must not be equal?

Give us a few more details here.

Rick B


Hi,
I am trying to generate a query that will give me the total number of
classes completed per month that take longer than 8 hours.
The table i am getting the informationfrom has the following fields ClassID,
DateStarted,DateFinished,Class1,Class2.
The results would look like:
Month Class1 Class2
Jan 5 4
Feb 0 2
Mar 8 6

Note that the date fields are using General Date as the format.

Any help is greatly appreciated.

Thanks
Carmen
 
The class1 and class2 fields are yes/no fields. The DateStarted could be
4/9/2004 10:54:20 PM and the Date Finished could be 4/10/2004 5:54:20 PM
with Class2 having a yes. So this would count as 1 that was over 8 hrs
during the month of Apr for Class2.

Carmen
 
Back
Top