You had sent an email asking for a fourth option, to include 6's also. That code would look like:
Code:
SELECT GNumbers.Numbers
FROM GNumbers
WHERE (((Left([Numbers],Len([Numbers])-1)) In (SELECT Left([Numbers],Len([Numbers])-1) AS Prefix
FROM GNumbers
GROUP BY Left([Numbers],Len([Numbers])-1)
HAVING (((Sum(IIf(Right([Numbers],1)=5,1,0)))>0) AND ((Sum(IIf(Right([Numbers],1)=6,1,0)))>0) AND ((Sum(IIf(Right([Numbers],1)=7,1,0)))>0) AND ((Sum(IIf(Right([Numbers],1)=9,1,0)))>0)))) AND ((Right([Numbers],1)) In (5,6,7,9)));
I highlighted in red what I added for the 6's.