Hi. I have created a query that uses an IIF statement as the criteria for the Action field. Depending on which "Queue" is selected, I want the results to...

I have a Microsoft Access 2003 query that checks a value in a form's combo box (the combobox returns a integer ID value) and uses that value as criteria for...

I have a query in which one date need to be filtered based on another field. If the field =1 , the data needs to be filtered showing only data where =. ...

I have a query which contains an IIF statement that checks for a value in a combo box in a form. It checks to see if it is null. If it is, then the query...

I am creating a database to retrieve performance information at different levels. The lowest level is an individual area, then going to a group area, then...

I have an iif statement in my query and the query works fine, but the data is not being stored into the table - the field is left blank. All the other...

Can an Iif statement be used in this append query? What I need is after WHERE ,,IIF is Null then I want only the appended. If is populated or Not Null...

Hello, I'm trying write an update query that evaluates 3 critiera. I want it to evaluate the critieria in one field and then update the values in the ...

I have a calculated field produces the following sentence "7 episodes per 2 months, max duration per episodes is 1 day" the problem is I need to say if this...

The code I am reviewing contains a nested IIf statement but does not test for a condition in the outer IIf: In the example: IIF(IIF(Field = "A","Display...

I am trying to create a query off a subquery. The sbuquery pulls in all of the data I need. Now to sort the data for the report. Expr1:...

I have the following IIF statement in the field line of a select query that I can't get to work. This is an option box that is a text field: Agency:...

In a query in Access 2007, I'm using the following nested IIF statement: App Status: IIf(="NEWACCT","Approved",IIf(="VOIDAPP" Or "MANLDEC" Or...

I created an IIF statememnt in a query: IIf(=0,"0",). =/ so I want my final result to display a "0" if =0 so you don't get a divide by zero error but if does...

is there something wrong with this? could it be that the field that I am comparing is another calcualted field? =iif( Between 0 And 15,"0-15�, iif( ...

I have a table with text parameters (table 1) and a second table with vlaues that relate to each parameter from table 1 (table 2). I want to design a query...

I have a this syntax located in the control source of a testbox on my...

This is a continuation of my question from 2 days ago. I have a field "Consent Status" that has data strings such as "Declined by Fam - PKO", "Declined by...

I am trying to create an IIf Statement to show if a date is OK or Overdue. My fields are "TargetDateOfPDA" and "ActualDateOfPDA". I want to create a new...

I am trying to run the below query to simply find data in a column that is a certain criteria, then taking data in another column and multiplying it and it...