Share via

output to report unique list of records from query

Scerri Simon at MFH 0 Reputation points
2023-08-16T07:51:47.2633333+00:00

query still not displaying unique records

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
899 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ken Sheridan 2,851 Reputation points
    2023-08-16T12:16:49.9066667+00:00

    Including the DISTINCT predicate in the query's SQL statement will, as you'd expect, return distinct rows:

    SELECT DISTINCT etc.............

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.