I know this is something stupid but it’s driving me NUTS
I have an Access database which has a table called Visitors with three fields (Counter, Login, DateAdded).
I want to display all the distinct logins along with their counter number and in order of their counter number, so I was thinking a statement like this
SELECT Counter, DISTINCT Login FROM Visitors ORDER BY Counter
But I get an error message. This works
SELECT DISTINCT Login, Counter FROM Visitors ORDER BY Counter
But then Counter is included in the DISTINCT part of the query and because Counter is an autonumber it returns every field.
Any ideas :h:
