Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Calculation within a column

Author  Topic  NhanLe Starting Member 3 Posts Posted - 2008-10-27 : 08:16:46 Date happening duration 11/11/2008 online 8:00 11/11/2008 offline1 1:00 11/11/2008 offline2 2:10 11/11/2008 offline1 0:20 12/11/2008 online 16:00 12/11/2008 offline2 0:30 How can I calculate for every day the duration of the online time? online - (sum(offline1)+sum(offline2) Result should be a resume for every day: date RealOnline 11/11/2008 4:30 12/11/2008 15:30 Looking forward for your help Thanks Nhan