Duplicate in a querie

  • Thread starter Thread starter Brendanpeek
  • Start date Start date
B

Brendanpeek

i need a query that will display the values in the field but i do not want
the query to show duplicate values.
 
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
 
Thanks That was great

Michel Walsh said:
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
Click to expand...
 
Back
Top