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:

SELECT FName, Count(FName) AS CountOfFName
FROM TableName
GROUP BY FName;

Create a second query such as:

SELECT TableName.FName, TableName.Market
FROM QueryName RIGHT JOIN TableName ON QueryName.FName = TableName.FName
GROUP BY TableName.FName, TableName.Market, QueryName.CountOfFName
HAVING (((QueryName.CountOfFName)>1));

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