jhayes7781
Last Activity: Apr 10 '07, 01:07 PM
Joined: Mar 27 '07
Location:
-
-
-
Yeah that is pretty close...i just want to get the record that its couting displayed. Say if your table had a 11 different kinds of shoes but shoe A. may be in there 20 times. I would want it to display:
Shoe A: 10
Shoe B: 5
Shoe C: 8
etc... for all 11 of the records it counted.
Any help? -
select count (distinct field name)
from table
where field name='X'
The results yield
Distinct field name
Count=11
I want it to show each of those 11 unique counts and all the records assoicated with them. That make more sense?Leave a comment:
-
COUNT function in SQL
I am using the COUNT function in SQL. I am getting it to display the total number of occurrences specified in my criteria. However, I would like for it to display it to show the record in the field for each count. Any suggestions? -
N/M that last post...I got it.Leave a comment:
-
How do I work this into other criteria that will sort on other unique fields?Leave a comment:
-
SUM function adding two fields in one table
I am trying to add the values of two fields in one table. Not sure how to get the SUM function to make this work. -
SUM function two different fields in one table
I am trying to add the values of two fields in one table. Not sure how to get the SUM function to make this work.
No activity results to display
Leave a comment: