To be or not to be: Unique

[Eric]

access 2007 on vista- number of records = 20K
When I try and pull unique months from my database and I get: 2007.01,
2007.02, 2007.02, 2007.03. As you can see, I get two of 2007.02 (out of 3k
2007.02 records). They look the same to me. My decimals are set to “autoâ€
so there isn’t a longer hidden number. If I filter on 2007.02 I get both
entries so Access does see them as the same number in filter mode but not as
unique when I query ? Any ideas?

 

[Jerry Whittle]

Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.

 

[Eric]

Here is the SQL:

SELECT DISTINCT history.[POS Month]
FROM history;

 

[Eric]

Update- This SQL works fine:

SELECT DISTINCT Round([POS Month],2) AS Expr1
FROM history;

I suppose the data could have number in the 16th (or higher) decimal place
that I can’t see (max decimal places shown is 15). I suppose “Filter†could
ignore this digit and that “query†acts on it. If so, I would consider this
a defect in the program.

Here is the SQL:

SELECT DISTINCT history.[POS Month]
FROM history;

Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.