Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Datasheet:edit data with Left outer join to a view
I am using an Access2000 ADP, connecting to a SQL 2000 backend. I have a datasheet that is based on the sql statement below SELECT VariousFields FROM Detail D INNER JOIN Product P ON D.ProductCode = P.ProductCode INNER JOIN Master M ON D.RefNo = M.RefNo LEFT OUTER JOIN...- arduk
- Thread
- Replies: 1
- Forum: Microsoft: Access Project (ADP)
-
Simple (?) MDX Query
I have constructed a sales cube (using MS SQL Server) Customers can be grouped by Region, and also by Corporate Banner (eg Caltex, McDonalds) SalesItem is the fact table, and there are two dimensions - Customer.Region and Customer.Banner I am trying to build a query that will display the count... -
Get the Root Directory of A Project
How do I return the root directory of the current project?? I have developed a web control that will be used on a number of pages, but it always references a file that is in the root directory of the current project (same location as web.config etc). How can I ensure that it always points back...- arduk
- Thread
- Replies: 7
- Forum: C# (C sharp): Microsoft
-
VS.net - Change the Virtual directory for a Web project
This should be very easy, but I can't seem to work out how to do it... I have a web application which I have developed in VS.net (c#) Initially, when I set up the web app, I mapped it to a virtual directory that was two levels deep ie if "VirtualDirectory1" is a virtual directory...- arduk
- Thread
- Replies: 0
- Forum: C# (C sharp): Microsoft
