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!

Register Log in
  • Congratulations strongm 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: *

  • Users: Bomac8
  • Content: Threads
  • Order by date
  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

    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