A distinct record

J

Jesse

I am trying to make a combo box that only displays one of
each record found in my "payment of" column of my
reciepts data table. What expression can I use in my
query so that one of each text is diplayed so that my
people only need to pick one. Please help if you can.
 
S

Steve Schapel

In the query design view, right-click anywhere on the background of
the top panel of the window, and then select Properties from the
pop-up menu. Set the Unique Values property to Yes.

In SQL view, it reads: "SELECT DISTINCT..."

- Steve Schapel, Microsoft Access MVP
 
Top