can somebody tell me why I get an error when executing following code in Access
SET Anzeige = (CASE WHEN Land = 'GR' THEN 'Germany ['+ ISNULL(UpTrend_Anzahl,0) + '¦' + Technik_Anzahl + ']'
the error says: a NULL value will be deleted by an aggregat or SET
If I do
SET Anzeige = (CASE WHEN Land = 'GR' THEN 'Germany'
any idea how to solve?