>Hi Chuck,
>What about :
>
>SELECT MyTable.field1,MyTable.Field2,Count(Mytable.Field1) as cntField1 ;
>FROM table1 ;
>GROUP BY table.field1 ;
>INTO Cursor MyCursor
>
>Your solution is the "GROUP BY" clause
>
>>Is there a way to run an SQL SELECT and get ALL the rows of data and still get a COUNT(*)? I have tried this, but it looks like like I'm just getting the last row of data along with the count. TIA, Chuck.

This will actually give you a count based on the value in field1. If all the values in field1 are unique (i.e. primary key), you will get a count of 1 in cntField1. If they aren't unique, then you will get an count of all records with that value in cntField1 and the other fields will have the vales of the last record physically in the table with that value in field1.

Ex.
field2      field1
ABC         VALUE1
DEF         VALUE2
GHI         VALUE1

Results
field1      field2      cntField1
VALUE1      GHI         2
VALUE2      DEF         1