I looked around but I didn’t find any similar posts.
OK, MS ACCESS database — I got a rather complex query that is pulling info from other tables and queries. The data it’s display is correct, but due to the nature of one of the queries it is referencing, it is showing the same data over and over again (correctly). Here is an example:
Employee Name | Vacation days | etc
John Smith | 10 | blah
John Smith | 10 | blah
John Smith | 10 | blah
bob Jones | 4 | yaddah
bob jones | 4 | yaddah
bob jones | 4 | yaddah
How can I get the query to display just one instance of each repeating record? This would help my reporting greatly.
