My report is grouped by distinct (no duplicates) alphanumeric Supply Codes from Table A. Those records are only selected if they match a Supply Code in Table B, in which there are duplicate Supply Codes. My report correctly shows only 1 instance of each Supply Code (there are no suppressed/hidden fields), but when I do a Count(Table A.Supply Codes) it counts the instances in Table B.
Table linkage is Table A.SupplyCode Left-outer-joined to Table B.SupplyCode.
Any ideas?
Table linkage is Table A.SupplyCode Left-outer-joined to Table B.SupplyCode.
Any ideas?