G
Guest
I am trying to count the number of instances that a particular phrase appears
in a field. I have been able to have the phrase identified, but I cannot get
an actual count.
The SQL below gives me a field of "Reason for Dispute" and the result is
"Not our patient" instead of an actual count. Can someone help me with the
missing part of this, please?
SELECT DISTINCT invoices.[Reason for Dispute]
FROM invoices
WHERE ((([Invoices]![Reason for Dispute])="Not our Patient"));
in a field. I have been able to have the phrase identified, but I cannot get
an actual count.
The SQL below gives me a field of "Reason for Dispute" and the result is
"Not our patient" instead of an actual count. Can someone help me with the
missing part of this, please?
SELECT DISTINCT invoices.[Reason for Dispute]
FROM invoices
WHERE ((([Invoices]![Reason for Dispute])="Not our Patient"));