With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!
SELECT qryTempSalesForCalculation.[Location Code], qryTempSalesForCalculation.[Group Code], qryTempSalesForCalculation.[Gross Sales], SWITCH( [Gross Sales] < [TIER 1 MINIMUM_Standard], "Less", [Gross Sales] > '[TIER 1 MINIMUM_Standard]', "More") AS [Normal Rebate Amount] FROM NA_Groups INNER JOIN qryTempSalesForCalculation ON NA_Groups.[GROUP CODE] = qryTempSalesForCalculation.[Group Code];
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.