Duplicates

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?
 
M

MPM1100

For your year list, you want to use a SQL statement:
SELECT DISTINCT YearField FROM TableName ORDER BY YearField;
 
Top