Sql query- group by more than 1 hour 1

[robinsoninho]

i have a table of time and dates and a value after it inn which i want to do a query which groups these values by every 3 hours e.g

my table
12/02/2001 00:00 6
12/02/2001 01:00 4
12/02/2001 02:00 8
12/02/2001 03:00 12
12/02/2001 04:00 7
12/02/2001 05:00 6


i want the query to do this
12/02/2001 02:00 18
12/02/2001 05:00 25

i cant find anything anywahere and its use ids for a chart in which the chart wizard allows grouping by 1 hour and not by more than 1 hour any help will be much obliged

cheers

 

[KenReay]

Hi

If I understand your question correctly how about:

a query containing a two "calculated" columns

SDate:Format(MyDateTimeCol,"dd/mm/yyyy")
Segment:Int((Format(Now(),"hh") / 3) + 1 )

then group on sDate and Segment



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[robinsoninho]

cheers that worked exactly how i needed it to