I know I should know this but I am drawing a big blank.
I want to create a query that pulls a number of fields from a table. But I want a certain field (the EncounterNumber) to be distinct.
What is SQL statement for doing this? Or the way for doing this in Access. Thanks