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

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> 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
 
+
cdclayton
post Mar 6 2006, 06:11 PM
Post #2

UtterAccess Veteran
Posts: 343
From: South Texas
There should be no problem with grouping on one field but counting another. Please provide more information about your structure and data.

Charles
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

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

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 11:57 AM