A distinct record

[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.

 

[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