Query Unique record?

[istone]

Hi everyone,
Is there a way to solve the following problem?
I have this query

ID Cust NAMECUS SumOfBASE Assests Lives

615 Cohn Real 5000
692 Gora 18 19387 5
692 Gora 833.06 19387 5
692 Gora 850.03 19387 5
692 Gora 833.06 19387 5
692 Gora 843.11 19387 5
692 Gora 1750 19387 5
585 Terwin 100 2841 2
585 Terwin 300 2841 2
585 Terwin 500 2841 2
652 Waterview 325

I would like to show Assests and Lives only once for each customer, so my final query will be like this:

ID Cust NAMECUS SumOfBASE Assests Lives

615 Cohn Real 5000
692 Gora 18 19387 5
692 Gora 833.06
692 Gora 850.03
692 Gora 833.06
692 Gora 843.11
692 Gora 1750
585 Terwin 100 2841 2
585 Terwin 300
585 Terwin 2415
585 Terwin 500
652 Waterview 325

Thanks in advance
Stone

 

[lespaul]

I think you can do that in a report, but not really in a query.

Leslie

 

[istone]

Thanks for your quick reply. You're right. I was able to do it in a report.
Stone