>Your solution has proved very usefull but I've run into another problem. In the select statement under the Count clause (Count(*) As nNumberOfRecords) can I include an expression that would filter certain entries.
>
>I was thinking about using something to the tune of:
>
> Count(*) for carrier="46" as nNumberOfRecords
>
>but that hasn't worked.
>
>Any suggestions?
>
>Thanks
>Kris H
Put it into where clause of select statement, e.g.
select *, count(*) as nNumberOfRecords from yourTable where YourCondition and carrier='46' into cursor curReport
If it's not broken, fix it until it is.
My Blog