I'm trying to get a count of the number of records in my SQL Server 2000 db that meet certain criteria. I have the following query:
(select count(*) as count from "PatientArrival"
where "PatientArrival"."PatientArrMechVentMetStatus" = '2')
It should return 3 records, but nothing is showing up in the textbox that I dragged the SQL Expression Field into.
Am I missing anything?