Can anyone help with my SQL statement query

[fluffyvampirekitten]

I keep getting blank results..


I can't seem to figure it out

Below is the code:

SELECT GROUPING.CATEGORY, GROUPING.FIELDMATCHED, GROUPING.INSTITUTION, Count(GROUPING.GROUP_NO) AS NO_OF_GROUP, DateAdd('m',-1,[LOADED_DATE]) AS LOAD_PERIOD
FROM (SELECT CATEGORY, FIELDMATCHED, INSTITUTION, LOADED_DATE, GROUP_NO FROM CrossSystemData)  AS GROUPING, (SELECT Start_Range, End_Range FROM Setting WHERE Type = 'SUMMARY_RANGE')  AS Range
WHERE (((DateAdd('m',-1,[GROUPING.LOADED_DATE])) Between [Range].[Start_Range] And [Range].[End_Range])) And ((GROUPING.CATEGORY)="POTENTIAL DUP") And ((GROUPING.FIELDMATCHED)="HIGH")
GROUP BY GROUPING.CATEGORY, GROUPING.FIELDMATCHED, GROUPING.INSTITUTION, DateAdd('m',-1,[LOADED_DATE])
HAVING ((GROUPING.INSTITUTION) Not Like "*UNKNOWN*");

Thanks in advance

[orange]

Reformatted for readability;

SELECT GROUPING.CATEGORY
	,GROUPING.FIELDMATCHED
	,GROUPING.INSTITUTION
	,Count(GROUPING.GROUP_NO) AS NO_OF_GROUP
	,DateAdd('m', - 1, [LOADED_DATE]) AS LOAD_PERIOD
FROM (
	SELECT CATEGORY
		,FIELDMATCHED
		,INSTITUTION
		,LOADED_DATE
		,GROUP_NO
	FROM CrossSystemData
	) AS GROUPING
	,(
		SELECT Start_Range
			,End_Range
		FROM Setting
		WHERE Type = 'SUMMARY_RANGE'
		) AS Range
WHERE (
		(
			(DateAdd('m', - 1, [GROUPING.LOADED_DATE])) BETWEEN [Range].[Start_Range]
				AND [Range].[End_Range]
			)
		)
	AND ((GROUPING.CATEGORY) = "POTENTIAL DUP")
	AND ((GROUPING.FIELDMATCHED) = "HIGH")
GROUP BY GROUPING.CATEGORY
	,GROUPING.FIELDMATCHED
	,GROUPING.INSTITUTION
	,DateAdd('m', - 1, [LOADED_DATE])
HAVING ((GROUPING.INSTITUTION) NOT LIKE "*UNKNOWN*");