Hi all,
I have a table (water) with the following fields:
date time FieldName Water
Water is the water quantity that wo give to a certain field.
e.g: 11/8/04 12:12:00 1 200
11/8/04 04:12:00 1 500
11/8/04 09:12:00 2 100
11/8/04 12:12:00 3 200
I want to select the water quantity from certain fieldName according to the first reading, thats mean the minimum time in the same date.
How I can build aquery that give me the first reading water for each field.
---> 11/8/04 12:12:00 1 200
11/8/04 09:12:00 2 100
11/8/04 12:12:00 3 200
thanks alot