Distinct records

[mrum73]

I have a table with the fields Market and FName.
is there a way query for the FNames that Show up in more than one Market. And then display the Markets and FNames?

Thanks

[mlcampeau]

I have a table with the fields Market and FName.
is there a way query for the FNames that Show up in more than one Market. And then display the Markets and FNames?

Thanks

Not sure of a way to do it with one query, but if you make one query such as:
[CODE=sql]SELECT FName, Count(FName) AS CountOfFName
FROM TableName
GROUP BY FName;[/CODE]

Create a second query such as:
[CODE=sql]SELECT TableName.FName , TableName.Marke t
FROM QueryName RIGHT JOIN TableName ON QueryName.FName = TableName.FName
GROUP BY TableName.FName , TableName.Marke t, QueryName.Count OfFName
HAVING (((QueryName.Co untOfFName)>1)) ;[/CODE]

This should give you your desired results. Just change your table/query names to the names you have used.