TOP Statement

[bodylojohn]

Hello Guys,

I have a question.

I have a query that looks like this:

Category Customer_ID
1 123444
1 233732
1 87667
1 3343
1 99876
2 123
2 775446
2 332334
2 22311
2 1121

Now, from Category 2 I want to see the top 3 and from Category 1 I want to see all.

I know I can't use Select TOP because it cuts random.
I just want to cut from Category 2.

Thank you in advance guys

 

[MStef]

Look at "DemoTop3A2000.mdb",
Open "Query2Union".