Difficult query

Hi,
Could you help me building a query?

Select average values by day .

The PROBLEM is that values for a D day are in fact values of D-1 day plus value of D day at 00:00:00.
eg: for day 08/24/1999 i average values in: ]08/23/1999 00:00:00 (excluded); 08/24/1999 00:00:00 (included) ].

thanks,
vincent Received on Tue Aug 24 1999 - 01:45:29 CDT