Hi Cetin:

I will repost as you advise.

Again thanks,

Mal

>Hi Malcolm,
>OLE DB message is right to a point but still works. I'm not clear if you really want this. A group by would get the last physically entered record's data for a field that's not part of aggregation (song_no here). That's you have :
>1...3...30
>1...3...23
>
>When grouped on singer_no you would get 23 for song_no (doesn't matter for room_no since it's all 1).
>
>

with thisform.ADOControl
>  .CommandType = 1
>  .ConnectionString = ;
>    [Provider=MSDASQL.1;Persist Security Info=False;]+;
>    [Extended Properties="]+;
>    [DSN=Visual FoxPro Database;UID=;]+;
>    [SourceDB=c:\mypath\mydatabase.dbc;SourceType=DBC;]+;
>    [Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"]
>  .RecordSource = "select * from mytable where room_no = 1 group by singer_no"
>endwith

This sample is OLE DB to VFP. VFP SQL is not a one-to-one implementation of ANSI SQL, with SQL server this might not work. I don't have it installed to test. Craig, Mark, JVP and many others could help you better than I. Please repost your question.
>Cetin