Query question??

[ddbrook]

I have a query that retrieves multiple records in my active accounts but I only want to show the user just 3 records of each active account. Some accounts have about 20 or more if it is apts.

Example of data:

name,cust#,account#
BANY LANDING APTS ,1269,4945800
BANY LANDING APTS ,1269,4945820
BANY LANDING APTS ,1269,4945890
BANY LANDING APTS ,1269,4945940
BANY LANDING APTS ,1269,4946090
BANY LANDING APTS ,1269,4946100

Thanks for your help!

ddbrook

 

[zambezibill]

Create a 2nd query based on what you already have and preface the SQL statement with the TOP predicate as in:

SELECT TOP 3 .........

Cheers, Bill

 

[ddbrook]

I guess I didn't make myself clear...sorry.

I have multiple customers and these accounts with multiple records can be in the middle of my query so TOP 3 is not going to work.

I need all customer accounts but only 3 of each one.

Thanks and hopefully you can shine some light now.

ddbrook

 

[danvlas]

What's the SQ?

Daniel Vlas
Systems Consultant
danvlas@yahoo.com