Duplicate in a querie

[Brendanpeek]

i need a query that will display the values in the field but i do not want
the query to show duplicate values.

 

[Michel Walsh]

SELECT DISTINCT fieldName
FROM tableName


or


SELECT fieldName
FROM tableName
GROUP BY fieldName



The second syntax can be expanded to include the number of time each value
occur, as example,with:


SELECT fieldName, COUNT(*)
FROM tableName
GROUP BY fieldName




Vanderghast, Access MVP

 

[Brendanpeek]

Thanks That was great

SELECT DISTINCT fieldName
FROM tableName


or


SELECT fieldName
FROM tableName
GROUP BY fieldName



The second syntax can be expanded to include the number of time each value
occur, as example,with:


SELECT fieldName, COUNT(*)
FROM tableName
GROUP BY fieldName




Vanderghast, Access MVP