Duplicates

  • Thread starter Thread starter Hendrix10
  • Start date Start date
H

Hendrix10

I am creating a form where users can select results based on
information in the list. One of the options is Year where on year can
appear more than once but I only want it to appear once. What would I
do so that it only appears once?
 
For your year list, you want to use a SQL statement:
SELECT DISTINCT YearField FROM TableName ORDER BY YearField;
 
Back
Top