Good afternoon,
I am looking for a way to count in a layer how many records have two fields distinct, and show the result in a text box.
Thanks
This is what I need if I use a SQL Statement:
SELECT distinct
[ProjectNumber]
,[ProjectPage]
FROM ProjecTables
And the count will be
SELECT COUNT(*)
FROM (
SELECT distinct
[ProjectNumber]
,[ProjectPage]
FROM ProjecTables
) as dt
Please advise