I have two tables IDENTICAL structure (as a matter of fact the structure was created from the other that is working)
I have a query to return DISTINCT dates works on one, the other returns all the dates.
The SQL:
Works:
SELECT DISTINCT GlucoseReadings.ReadingDate
FROM GlucoseReadings
ORDER BY GlucoseReadings.ReadingDate;
Doesn't work:
SELECT DISTINCT Results.ReadingDate
FROM Results
ORDER BY Results.ReadingDate;
The two tables: GlucoseReadings and Results
The Query: DateQuery
If I run the DateQuery on the GlucoseReadings Table , works, returns only Distinct Dates
Inside the same Query if I change to the Results Table in returns every single record
I am attaching the example database, all you have to do is go to query design and change the field from one query to the other to see the STRANGE behavior.
I don't have enough hair to pull out anymore on this one.
example.zip