Hi All,

Been a while since I posted http://www.access-programmers.co.uk/ubb/smile.gif Things have been going well...but am now stuck http://www.access-programmers.co.uk/ubb/frown.gif

Here is what I need to do...

I have a table with circa 400k telephone numbers in it. These numbers have an analysis code next to them which is the first 6 digits of the number, thus enabling me to group numbers by range and type/tariff. There are 62 different analysis codes.

What I need to do is design a select query that gives me 2 records for each analysis code....how do I get my query to limit the selection of records for analysis codes?

Any help is as always greatly appreciated http://www.access-programmers.co.uk/ubb/wink.gif

Cheers,

Tommy B

Look up the Top values, this question has been answered recently or very similar, if you search I'm sure you'll find your answer

Will do. Cheers Rich.

Tommy B