Limiting Record Selection?

[Tommy B]

Hi All,

Been a while since I posted

Things have been going well...but am now stuck

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

Cheers,

Tommy B

 

[Rich]

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

 

[Tommy B]

Will do. Cheers Rich.

Tommy B