returning all records - not sure why!

[Allie]

I have a table called RECORDS
Then a query which sums absences by employee badge #
Here:
SELECT Records.BADGE, Sum(Records.DAYS) AS [Sum Of DAYS], Min(Records.DATE)
AS [First Absence DATE]
FROM Records
GROUP BY Records.BADGE;

Then a query I want to use to report on:

SELECT Records.BADGE, Records.NAME, Records.CC, Records.TEXT, Records.DATE
FROM Records
INNER JOIN [Records Query]
ON Records.BADGE = [Records Query].BADGE
WHERE [Records Query].[First Absence DATE])>=7

For some reason, it is returning ALL the records instead of just the records
with more than 7 absences.

Any ideas on what I have done wrong?

 

[Allie]

If I could delete this I would.
The last field should say SUM OF DAYS >7
UGH!