My "real" tables are not set up that way...just a quick can anyone answer this question.
That is good news, but why not show the real table.
Code:
DELETE * from [Table 1]
Where [table 1].STAR
IN
(SELECT QQ.STAR
FROM [Table 1] as QQ
GROUP BY QQ.STAR
Having count(Star) <3);
I'm not sure where your table 2 fits or why it exists since it can be deduced from a query on table 1
Code:
SELECT [Table 1].STAR, Count([Table 1].STAR) AS CountOfSTAR
FROM [Table 1]
GROUP BY [Table 1].STAR
Having count(Star) <3;
As JoeM said Steve is advising you on best practices. Your Access journey will be a little less hectic if you heed the advice.
Good luck with your project.