Looking for any information to see if what I am asking for can be done.
Below is a query that I have that will list the amount of a given interfaces for the entire year. But what if I want to find this information by allowing the user to insert the date range. Will it be possible to insert a date range into said query? If I am looking at this the wrong way any suggestions?
ExecuteSQL ( "
SELECT COUNT (InterfaceName), InterfaceName
GROUP BY InterfaceName
ORDER BY 1 DESC"
;Char (9) & "- " ; "" ; Year ( Get ( CurrentDate ) ) )