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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Bomac8

    Convert IIF with switch statement to Case

    I have a column in a query that calculates regsales base on some Id's and dont think my CASE statement is correct. SUM (LOTOSMIS_ACC_TYPE.sing_ind * LOTOSMIS_RET_DAILY.grs_amn * iif( gm_cd in (1105, 2123, 2124, 2150, 2152, 2191, 2192, 5143, 5145, 5146, 5245, 5253 )...
  2. Bomac8

    Convert Ms Access IIF to SQL Server Version

    Sure. I have an access application tht I m trying to convert to SQL server. I have to get the data from an Oracle database accessed thru a link server. I bring some of the data in to two temp tables and I run this query to insert the data into an SQL server table. The table BEGIN TRANSACTION...
  3. Bomac8

    Convert Ms Access IIF to SQL Server Version

    THanks for all the help.The statement "IIf(([LOTOSMIS_RET_DAILY]![GM_CD]=6150 Or...
  4. Bomac8

    Convert Ms Access IIF to SQL Server Version

    I am in the process of converting an msaccess application to SQL Server and I am having trouble converting this code to a case statement IIf(([LOTOSMIS_RET_DAILY]![GM_CD]=6150 Or...

Part and Inventory Search

Back
Top