I am writing a report for Logging the Historical values in to the report for
the specified time .
I need to have the minimum / Maximum and the Average values from the database
for every hour and  for the specified 24 hours.

 

The report will be like this

 

From    To           Min          Max           Avg         Current

00:.00   01:00    19.75      20.33        20.11         20.33

01:00    02:00    19.76      20.32        20.14         20.32

.

.

.

 

This will be required for 24 hours.

 

Please note that I am getting the @startDate and @Enddate from a different programme.

 

Please let me now any workaroud for this at the earliest as I am not been able to write any formula to extract the per hour value from my database which is a process historian providing data through a .mdb file

 

I am getting the desired results now!!