Hi all,
I need your help to build the following query:
I have the following table :
Date/Time Sum1 Sum2
In the table I have three data to each day in three hours,I mean e.g:
14/11/04 6:00 AM 40 50
14/11/04 15:00 PM 60 70
14/11/04 11:00 PM 100 150

and like these data to other days.
I have to build a query to caculate the difference between time to time.
I mean the output of the query for the example table will be:
14/11/04 6:00~15:00 20 20
14/11/04 15:00!11:00 40 80

Please help me...
Best regards...