General information
Category:
Reports & Report designer
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only