You also use the SELECT...TOP n sql statement as well to perform you task.
Where n is occurs most offen Work_Date in your databse. Exmaple, over here I put 5 that mean I wish to retrieve the top5 Work_Date that occurs most offen.
Code:SELECT TOP 5 Work_Date FROM Work_History WHERE Work_Date <> "";




Reply With Quote