S Steve Schapel Feb 2, 2006 #2 New, In design view of the query, right-click anywhere on the background of the upper panel of the query design window (the part where the table(s) are shown), and select Properties from the pop-up menu. Set the Unique Values property to Yes.
New, In design view of the query, right-click anywhere on the background of the upper panel of the query design window (the part where the table(s) are shown), and select Properties from the pop-up menu. Set the Unique Values property to Yes.