T
tekari
Hi,
I'm trying to run an access query to give me only unique values in a
query. This would seemingly be simple to me. I know that I can right
click and then hit properties and select "Unique Values". Which would
appear to work, but here is my problem...
When I run this query with "Unique Values" turned on without any
modification on a single column I end up getting about 366 unique
values.
Now if I take the same query and hit the "group by COUNT" button it
returns 455.
Am I just misunderstanding the functionality of COUNT? Shouldn't this
return the number of records given the parameters I set in the
criteria?
The only thing I can think of is that if I select "COUNT" that ACCESS
ignores the fact that I also have the parameters set to Unique Values?
Is there any way around this if thats even the issue?
Thanks in advance,
-Eric
I'm trying to run an access query to give me only unique values in a
query. This would seemingly be simple to me. I know that I can right
click and then hit properties and select "Unique Values". Which would
appear to work, but here is my problem...
When I run this query with "Unique Values" turned on without any
modification on a single column I end up getting about 366 unique
values.
Now if I take the same query and hit the "group by COUNT" button it
returns 455.
Am I just misunderstanding the functionality of COUNT? Shouldn't this
return the number of records given the parameters I set in the
criteria?
The only thing I can think of is that if I select "COUNT" that ACCESS
ignores the fact that I also have the parameters set to Unique Values?
Is there any way around this if thats even the issue?
Thanks in advance,
-Eric