Before you start writing this code you should check out the Data, Import External Data menu item. This will allow you to create a query or connect to an existing SQL Server...

Another option for this situation is to create a User Defined Function (UDF) to do the initial calculations and then refer to the UDF results in the final calculations

Check out the presentation by Andy Novick at http://www.novicksoftware.com/Presentations/UserDefinedFunctions/User-Defined-Functions-presentation.htm

He also wrote a very good book about UDFs.

Thanks, but I just found the following in another newsgroup:

/****** Object:  User Defined Function dbo.DaysInMonth    Script Date: 03/17/04 11:47:31 AM ******/

CREATE   FUNCTION DaysInMonth

(@day INT, @yr INT, @mon INT)

RETURNS INT

AS

-- Return...

Thanks

That seems so cumbersome. This means that if the formula for subtotal1 changes, then I have to change the formula for grandtotal also. Why is something that was so easy...

Yes, it is a brand new computer with W2K sp4, SQL2k sp3 and all of the security patches etc.

The data is dumped in this format from the corporate financial mainframe system. I am creating a datawarehouse for reporting purposes and trying to decide how much effort we should put into...

Steve, thanks for the quick answer, how come you prefer the option that does not use dynamic sql? I used dynamic sql alot in MS Access and would like to...

Sorry that I did not make myself clear. What I would like to be able to see, is the descriptions for all of the tables when the Table folder is...

Thanks for the tip, but that was not the problem. I discovered that for some unknown reason the .tql files were compressed and therefore did not show up in the...

You can connect your Access database to the SQL Server, create a query based on the SQL tables or views, then convert the query to a Make Table query, run...