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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel - Refer to Column on current row
Hi, if i write a formula such as: =IF($C:C=3,IF($J:J="N/A"," ",(IF($J:J=""," ",(IF(MONTH($J:J)=12,$L:L," "))))),"") will it treat $C:C and $J:J as referring to the value in column C of the row the formula appears in? Thank you.- RHelman
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
SQL Query Efficiency
Hello, I have a query where I am essentially Summing the total cost of each order by customer. I have several tables: Customers, Orders, OrderedUpgrades, Upgrades; each with foreign keys linking them. I have two SQL queries that work, my question is, which is more efficient and is it preferable...- RHelman
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Document Library - Left Click not working
Hello, The below question is in regards to SharePoint 2007. I have a user who is unable to open a document from a document library with a left click, the left click is essentially ignored. In order to open the document, he needs to right click, select Document->Edit Document. He is running IE...- RHelman
- Thread
- Replies: 1
- Forum: Microsoft: SharePoint
