select only 1 of each different number....

E

emmy128

Hi

i have two columns, one for the employee, and one for the job number. Some
of the employees have the same job numbers, but many of them have a different
one.

i want to create a drop down box to list only one of each job number, so if
i could put a querie together that isolates one of each single number, then i
could link the drop down box to another form.

How would i be able to set up a querie that only displays one of each
different number only??

Help!!
 
Top