I am trying to populate a table named Metrics using formula queries. I populated several fields from the Opportunities table with no problem. See Attachment. I am trying to populate # QWT Leads (number of qualified water treatment leads) from the Leads TBL with no success using the following formula query:
var text QUERY = "{145.OAF. ' " & FirstDayOfMonth([Month (First Day)]) & " '}AND{145.OBF. ' " & LastDayOfMonth([Month (First Day)]) & " '}AND{80.CT. ' " & "Qualified" & " '}AND{81.CT. ' " & "Water Trmt" & " '}";
Size(GetRecords($QUERY, "brravks49"))
145 is a date field, 80 is the Lead Status and 81 is the lead type, all in the Leads table and "brravks49" is the Leads Table.
What am I doing wrong?
------------------------------
Denis Rochat
------------------------------
