First number only if the number is repeatable

[Rainbows5.]

HI
i have a form which has a drop down box in it


this drop down box shows me all the contract numbers i have used in a table called Issues. there are times when that contract number could be repeated how can i get it that it only shows the first contract number not the repeatable ones .
thanks steve

[CJ_London]

please clarify - how would a contract number be repeated and how do you determine which is the first one

Also provide the sql to the dropdown rowsource.

it may be all you need is something like

SELECT DISTINCT ContractNum FROM myTable

[NoellaG]

Use a select distinct instead of a select in the Rowsource statement

[June7]

You don't have a table of contracts where contract number would be unique?

[Rainbows5.]

[QUOTE=Rainbows5.;534853]HI
i have a form which has a drop down box in it
this drop down box shows me all the contract numbers i have used in a table called Issues. there are times when that contract number could be repeated how can i get it that it only shows the first contract number not the repeatable ones .
thanks steve[/QUOT

Hi the database we use is mainly for action requests . some of these action could be on a certain project /contract number . if 3 action requests we entered on the same same project/contract number in my dropdown box i will see 3 numbers the same but it would be better if i only seen one of them because all 3 will be retrived


thanks steve

[CJ_London]

So you have your answer in posts 2 and 3 or the better option in post 4 assuming your data is normalised