UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> group by a field with interval value    
 
   
littleneo
post Feb 17 2006, 02:48 PM
Post #1

UtterAccess Veteran
Posts: 352



Hi,

I need to run a query to get count of one field, but group by another field with interval value. The query result should get as following:

Fld1 CountOfFld2
1.0~1.9 xx
2.0~2.9 xx
3.0~3.9 xx
...

Do you know if there is a way to query on it?

Thanks a lot for your kind help!
Go to the top of the page
 
+

Posts in this topic


Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 05:25 PM