Need help with eliminating/sorting dates.

[joe.blow]

I have my data, in this particular scenario the data is dates (day/month/year). There are numerous dates., In my scenario I need to eliminate all data entries that DO NOT repeat 3 or more times. How would I go about doing this or what would the correct equation be to input?

[June7]

Maybe:

SELECT * FROM table WHERE datefield IN (SELECT datefield FROM table WHERE Count(*)>=3 GROUP BY datefield);

[joe.blow]

Sorry, can you explain a little more in depth? Sorry I am very new to this program. What does * mean? thank you for your response!

[June7]

The * is wildcard. Open query builder for a new query, switch to SQL View, should see the * already in the statement. If you want to explicitly list desired fields, remove the *.

The query might should be:

SELECT * FROM table WHERE datefield IN (SELECT datefield FROM table GROUP BY datefield HAVING Count(*)>=3);