462 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
3
votes
4
answers
172
views
Can we do an assignment operation in the true/false part of IIF in VB.net?
Can we do an assignment operation in either true or false parts of the IIF function of VB.net?
Public Sub Main(args() As string)
Dim score As Integer = 0
DIM scoreString As String = &...
-3
votes
1
answer
98
views
Access IIF statement to choose values from multiple tables
I have 3 Access 2010 tables cont, cond and prop.
All tables have 3 fields: table cont the key ID_cont
and the fields cond_ID and prop_ID that are related
to the keys ID_cond and ID_prop of cond and ...
0
votes
1
answer
58
views
Access report across three tables
I'm trying to run a report in Access with values from three tables (there are more fields in the actual tables I'm working with but they aren't relevant to this question:
tblUsers
UserID (pk)
LName
...
1
vote
0
answers
26
views
SSAS Cube measure IIF issue
I am working on creating a new cube measure QTD, in an SSAS cube.
The requirement is to display the Measure YTD directly when the current month is January, February, or March (Q1). The initial code I ...
1
vote
1
answer
38
views
jooq iif or nvl2 in request
I can’t figure out what I’m specifying incorrectly, null values from the STUDENT.CURRENT_CURS_ID column are not processed by iif or nvl2 and in general this student with a null value is not included ...
4
votes
2
answers
499
views
Replacement for VBA IIF function
I am working on an Excel project that involves converting an large set of Excel 4.0 macrosheet functions to VBA. These functions make extensive use of the worksheet IF(condition,ifTrue,ifFalse) ...
0
votes
0
answers
66
views
Access query IIF statement not displaying result
This should be a simple one but I have so far been unsuccessful. In access query, I am using the expression builder within a query to pull information from a table.
FirstName: IIf(Len([tbl_Associate].[...
user avatar
user16800302
0
votes
0
answers
31
views
SQL Query not includes valid result in Left Join with Where Not Equal To [duplicate]
I have a SQL query which does not perform as expected and returns incomplete results. In the query below, valid t1 rows are not included in the query results if there are no matching ids in t2.
Select ...
0
votes
1
answer
141
views
Aggregating Members calculated with IIF / CurrentMember conditions
An MDX newbie here.
I am trying to define and aggregate a custom measure which contains an IIF condition.
Suppose, for this data model:
Category
Name
ItemType
Price
CatA
Item1
Normal
4.0
CatA
Item2
...
0
votes
1
answer
138
views
Access VBA SQL statement received syntax error when attempting to INSERT values
I'm using Access VBA to insert values into a table based on information from a form. The SQL statement is throwing a syntax error, however, if I pull the SQL into the query builder it will run so I'm ...
0
votes
0
answers
73
views
How do I properly include an IIF Statement in a Dynamic SQL Statement without getting an Error
The code I have below was working, it was creating more code that created code that set-up the extended properties for a given table. But we wanted to start pulling pre-existing column descriptions ...
0
votes
1
answer
200
views
SSRS IIF Statement With Nested IIFs
I am trying to convert numeric months to text in SSRS Report Builder. I am having trouble with the expression needed to make this work. Here is the expression I have:
=IIF(Fields!MonthYear.Value = 6, &...
1
vote
1
answer
186
views
Custom Field in Query for MS Access Issue
I am trying to put a custom field in a query. My other 2 have come off without a hitch, but I cannot for the life of me figure out what I am missing to get this one to work. I've tried dozens of ...
-2
votes
1
answer
42
views
Visual Studio function IIF
I use Visual Studio 2017, and I have an expression like this:
=Microsoft.VisualBasic.Strings.Trim(Fields!QUESTION.Value) &
" Average:" &
ROUND(AVG(fields!...
0
votes
1
answer
155
views
Expression within IIF in Microsoft Access Expression Builder
I want to perform a calculation if the value in a particular field is greater than zero. Specifically, if the value in Field 1 > 0, I want to calculate the percent total from Fields 2 and 3. (Note ...