>Nadya,
>
>I wish you well in this...

Thanks. How to translate:

SELECT MainInfo.*, ;
sum(iif(MainInfo.Category = "1",1,0)) as Category1Count, ;
sum(iif(MainInfo.Category = "2",1,0)) as Category2Count ;
from MainInfo inner join NamesInfo ;
on MainInfo.CrediID = NamesInfo.CrediID ;
where MainInfo.ccode = "01" and ;
MainInfo.town in (select Town from SelectedTowns) ;
and NamesInfo.LastName like ?NameInput ;
group by MainInfo.CredID into cursor curResult

into SQL server select command?

(If I'm going to use my data model)
>
>>>Does this mean you will be staying with your current employer longer than originally anticipated?
>>>Tracy
>>>
>>They gave me a one month trial period as a WEB developer. If my performance is not going to be adequate, my eployment here will be terminated...
>>