>I'm not sure...did you start a new thread in SQL Server so Sergey or Mike Levy can answer it? *grin*

Not yet, but I already pointed Sergey to this thread. Now I was suggested so many options (some free and some not), that I can be overvelmed (?sp). I like AVFpages demo so far...
>
>>>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...
>>>>