hide duplicates ?

[piet123]

(sorry, not sure which post to submit to)

- the Table 'Jobcard' has a (text)field named PLACE.

- on the Form 'Jobcard', the user enters any! description into the PLACE field.

- many 'Jobcards' can have the same PLACE; so the Table records many 'duplicates' of the PLACE Field, as it should. this is OK.

- on another Form i have a comboBox to run a Report(based on a Query)
- this comboBox gets it's list from the PLACE Field in the 'Jobcard' Table.
- therefor the list will show 'duplicates'

how do i tell the Table? or cboBox? or Query(for Report)? to HIDE the 'duplicate' text in the cboBox...
!(EXCEPT FOR THE 1ST text entry for which there are 'duplicates')!

i hope you know what i mean.

any advice PLEASE!

thanks.
Piet.

 

[FoFa]

SELECT J.PLACE
FROM JobCards J
WHERE J.PLACE IS NOT NULL
Group by J.PLACE
Order By J.PLACE

 

[joeselch]

You could also do it this way (which, to my feeble mind, seems more intuitive - using DISTINCT instead of GROUP BY):

SELECT DISTINCT Jobcard.PLACE
FROM Jobcard
WHERE Jobcard.PLACE IS NOT NULL
ORDER BY Jobcard.PLACE;