To query repeated records

[kentck86]

Hi Guys,

My access table are having 3 column which i intended to shows status in column C as "confusion" is there is repetition in column A as long as column B is the same value.Else, column C shall return with "NO".





thank you

[orange]

Please step back and tell readers WHAT you are trying to do in simple business terms.
We have no context for your question. Until we know what you are trying to accomplish, we can not offer focused advice on HOW to achieve it.

[June7]

Can't do this calc in table. Build query with subquery or domain aggregate DCount() function.

What you show appears to be a query (indicated by the Expr1 field) not a table. So Status is a calculated field in query, not table?

The example provided does not include duplicates.


Query1
SELECT phyCellID, Expr1, Count(Expr1) AS CountOfExpr1 FROM queryName GROUP BY phyCellID, Expr1;

Query2
SELECT queryName.phyCellID, queryName.Expr1, IIf([CountOfExpr1]>1,"C","NO") AS Status
FROM Query1 INNER JOIN queryName ON (Query1.phyCellID = queryName.phyCellID) AND (Query1.Expr1 = queryName.Exp