Kris,

SELECT ... SUM(IIF(Carrier = "46", 1, 0) AS nNumberOfRecords

If you are using ANSI SQL-92, use

SELECT ... SUM(CASE WHEN Carrier = "46" THEN 1 ELSE 0 END) AS nNumberOfRecords

The ANSI SQL is a good idea if you ever expect to upsize to an SQL database.


>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