hi there, i've created a table named "Table1" which contains "Values" field and wrote the sample data you have below. afterwards, i went to the query and created a new one using qbe (query by example) window but i cannot show it to you. instead try to swith to SQL screen from your qbe and type this. then you can switch back to qbe window to see what i mean.
SELECT Table1.Values, Count(Table1.Values) AS CountOfValues
GROUP BY Table1.Values;
hope this one would help you a lot.
Originally posted by Glimmer
I have a table that contains a series of numeric values, e.g.
what I am attempting to do is to run a query that displays the instances of each value. For example and using the above values: