W wxdqz New Member Aug 21, 2008 #1 Hi, If I have a field which has a number value I would like to use an sql statement to select the "number" which occurs most within the table. eg. 7 7 7 7 8 8 8 9 9 9 might be spread accross 10 records but I want the number 7 to be returned.
Hi, If I have a field which has a number value I would like to use an sql statement to select the "number" which occurs most within the table. eg. 7 7 7 7 8 8 8 9 9 9 might be spread accross 10 records but I want the number 7 to be returned.
