need to calculate the number of days.

SELECT     LabID, OpenDate AS [Date Opened], CaseNum, CaseYear, Act, Disposition, ?Totol Days FROM         dbo.tblLabourFiles
 
I need to do a total of days Prior to April 1, 2011
OpenDate AS [Date Opened]
 
Mathieu Alexandre Cupryk www.omegalove.com ...