SQL as row source for a combo box

[George Too]

Hi all,
This is probably simple but here it goes: I have a simple SQL statement as the row source for a combo box. The statement pulls the year from a date field. Every record has a date ranging from 1999 to date. The problem I'm having is that the year repeats as many times in the combo box as it exist in the table. I want the combo box to show the year only once, so if year 1999 happens 100 times in the table I want the combo to show it only once.

This is the statement I'm using:
SELECT Year([DateComplaint]) AS theYear FROM tblMain;

Thanks for any help.
George Too

 

[BryanT]

Hello George

Have you tried
SELECT DISTINCT Year([DateComplaint]) AS theYear FROM tblMain

Bryan

 

[George Too]

I new it was something simple like that. Thanks BryanT.