it takes a long time before the two messageboxes below

(more than 1 minute)


= MESSAGEBOX ("before count")

SELECT CL
COUNT TO IMP_SELECT

= MESSAGEBOX ("after count")

the table has about 10,000 records

Is the a better way to count records ?