Information in this article applies to Microsoft SQL Server 2012. The instructions for earlier versions of SQL Server, including versions 2008 and 2005, are similar.

At Microsoft Build, SQL Server 2025 enters public preview with major enhancements in AI integration, performance, reliability and developer tools -- reaffirming Microsoft’s continued investment ...

I've done reports like this in Access before, and it's perfectly fine for this purpose.<BR><BR>But they will be running SQL Server 2005 on the back end.

SQL Server supports dates from Jan. 1, 1753, to Dec. 31, 9999. Access supports dates from Jan. 1, 100, to Dec. 31, 9999. You can’t upsize Access tables that contain dates earlier than January 1 ...