Question:
How can I set an SQL query (Access database) to retrieve the tag’s maximum, minimum, and average values?
Solution:
To do so, you must use MAX, MIN, and AVG functions.
Example of SQL query:
SELECT MAX(Historic.TagDemo1) AS MAXIMUM, Min(Historic.TagDemo1) AS MINIMUM, AVG(Historic.TagDemo1) AS AVERAGE
FROM Historic
