It appears you have two tables and are trying to find records where DR PH in
the first table is not equal to DR PH in the second table or Where DR FX is
not equal to DR FX in the second table.

It also appears that you are trying to group the results so you return only
one record for these conditions being true.  HOWEVER, assuming that A.ID
(and B.ID) are unique values in the two tables I can see no reason for
grouping the results.

I would expect that you would get the same results with the following query.

SELECT A.[DR CNTY], A.[DR ID], A.[DR NAME]
, A.[DR PH], A.[DR FX], B.[DR PH], B.[DR FX]
FROM [Main TRKG TBL] AS A INNER JOIN [Main TRKG TBL1] AS B
ON A.ID = B.ID
WHERE (((B.[DR PH])<>[A].[DR PH])) OR (((B.[DR FX])<>[A].[DR FX]))
ORDER BY A.[DR CNTY], A.[DR NAME];