Need Maximum Value by Day

B

bill

I have annual data tables with 24 hourly values per day.
There are multiple columns containing different data
values, or parameters.

I need to do some quality control checks before going
further and cannot find a way to find the daily maximum
value (i.e., one per day) where it exceeds a certain
criteria.

After this probably simple coding I will also need to do
some daily/month/annual statistics where data exceed
certain criteria (variable by parameter, or column).

Any ideas are appreciated!
 
V

Van T. Dinh

Try something like:

SELECT DateValue([DateTimeField]) as MyDate,
Max([ReqField])
FROM [YourTable]
GROUP BY DateValue([DateTimeField])
HAVING Max([ReqField]) > [CertainValue]

HTH
Van T. Dinh
MVP (Access)
 
B

Bill

Thank you Van - I will give it a try!

Bill

-----Original Message-----
Try something like:

SELECT DateValue([DateTimeField]) as MyDate,
Max([ReqField])
FROM [YourTable]
GROUP BY DateValue([DateTimeField])
HAVING Max([ReqField]) > [CertainValue]

HTH
Van T. Dinh
MVP (Access)

-----Original Message-----
I have annual data tables with 24 hourly values per day.
There are multiple columns containing different data
values, or parameters.

I need to do some quality control checks before going
further and cannot find a way to find the daily maximum
value (i.e., one per day) where it exceeds a certain
criteria.

After this probably simple coding I will also need to do
some daily/month/annual statistics where data exceed
certain criteria (variable by parameter, or column).

Any ideas are appreciated!
.
Click to expand...
.
Click to expand...
 
Top