A distinct record

  • Thread starter Thread starter Jesse
  • Start date Start date
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.
 
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
 
Back
Top