Hi,

I have a field called fnProject within my db.

Within this field there are many values, so for instance I could have 20 copies of Testvalue1 in my list.

What I do is use a dynamic menu to display this information, but the problem i'm having is that I only want to show one of each value whereas now there is 20 copies of Testvalue1 in my list.

Do I use a filter to do this? Any help/examples would be great.

Thanks

BTW

This is what I'm trying to do.

At the moment my menus like this

Testvalue1
Testvalue1
Testvalue1
Testvalue1
Testvalue1
Testvalue1
Testvalue2
Testvalue2
Testvalue3
Testvalue3
Testvalue3

What I want is:

Testvalue1
Testvalue2
Testvalue3

Create recordset with GROUP BY. Something like:
SELECT fnProject
FROM HereGoesNameOfTheTable GROUP BY fnProject

Insert this data into list/menu.