From xTab to Macro

[ReubenPatterson]

Very newbie question...I have an xTab query that sums records by a simple:

TRANSFORM Count(TBLMaster.FldChannelNumb) AS CountOfFldChannelName
SELECT TBLMaster.FldChannelNumb, Count(TBLMaster.FldMarket) AS CountOfChannelProblem
FROM TBLMaster
WHERE (((TBLMaster.FldChannelNumb) Is Not Null))
GROUP BY TBLMaster.FldChannelNumb
PIVOT TBLMaster.FldMarket;

and I have a macro that send a report with the needed fields via outlook. My question is; how do I best create a trigger so the report is sent only with these records when the total reaches 3 in the "CountOfChannelProblem" column?

Thanks in advance.

[MMcCarthy]

Try this...

TRANSFORM Count(TBLMaster.FldChannelNumb) AS CountOfFldChannelName
SELECT TBLMaster.FldChannelNumb, Count(TBLMaster.FldMarket) AS CountOfChannelProblem
FROM TBLMaster
WHERE (((TBLMaster.FldChannelNumb) Is Not Null))
GROUP BY TBLMaster.FldChannelNumb
HAVING Count(TBLMaster.FldMarket) >2
PIVOT TBLMaster.FldMarket;