Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anil Sharma
  Where is Anil Sharma?
 ludhiana
 India
 Anil Sharma
 To: Patrick Danso
  Where is Patrick Danso?
 Accra
 Ghana
 Patrick Danso
 Tags
Subject: RE: Selection Record per Member
Thread ID: 345570 Message ID: 345573 # Views: 48 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, May 24, 2012 2:58:11 PM         
   


> Hi,
>
> I have a table with records of member’s payments. So this table have all payments of all members. I want to select ONLY one record per member from this table. How can i do this?
> Thank you

you can use select distinct fieldname .....
better if you post with data.



Anil


Accounting Software

Web Development

Accounting, Inventory, Hotel Management, Restaurant Kot Billing, MLM, Excise Accounting and much much more!.
My Blog

ENTIRE THREAD

Selection Record per Member Posted by Patrick Danso @ 5/24/2012 2:17:33 PM
RE: Selection Record per Member Posted by Cetin Basoz @ 5/24/2012 2:47:07 PM
RE: Selection Record per Member Posted by Anil Sharma @ 5/24/2012 2:58:11 PM
RE: Selection Record per Member Posted by Patrick Danso @ 5/24/2012 4:23:12 PM
RE: Selection Record per Member Posted by Tamar Granor @ 5/24/2012 10:18:10 PM
RE: Selection Record per Member Posted by Patrick Danso @ 5/25/2012 1:22:39 PM
RE: Selection Record per Member Posted by Anders Altberg @ 5/26/2012 2:45:14 PM