T
tina
to set the Unique Values property as follows
open the query in design view.
right click in the upper portion of the window, and
select Properties from the shortcut menu.
in the Query Properties box, set Unique Values to Yes.
fyi, if you put the cursor on the Unique Values line and
press F1, Access will take you to that topic in the Help
file. and the same technique will work in many areas in
Access - makes it a little easier to get info from Help.
open the query in design view.
right click in the upper portion of the window, and
select Properties from the shortcut menu.
in the Query Properties box, set Unique Values to Yes.
fyi, if you put the cursor on the Unique Values line and
press F1, Access will take you to that topic in the Help
file. and the same technique will work in many areas in
Access - makes it a little easier to get info from Help.