I am working in Visual Studio 2005 and need to create a report that does the following in its columns:
Column A: (range of numeric data coming from TABLE A)
Column B: (another range of numeric data coming from TABLE B)
Column C: If (TABLE A.data= 1 OR 2) AND (TABLE B.data= 3 OR 4) THEN populate the corresponding cell in Column C with a 1 for TRUE.
Column D: Sum of TRUE responses
The FX associated with Column C insists on starting with "=" and then a function, but I cannot find any reference as to which function would be appropriate- =IIF seems close, but all the examples I find are written in this format:
result = IIf(x = y, value1, value2)
Which looks more like code you dump into the query itself as it doesn't start with an "=", but I need Visual Studio to display the result in Column C.
Any advice would be whole-heartedly appreciated.
