Duplicates

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

 

[MPM1100]

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