I have a field "SumOfQty" in a query that I want to use an IIF statment in the criteria: If !! is checked then "SumOfQty" criteria is 0. else 0. The 0...

I have a query have has the 5 variations of the following IIF statement: Bag Total: IIf(" " & & " " Like "* BAG *",,Null) this statement says to add up if the...

Sorry fist post didnot aline right.I need to create a query that can search between to field’s Low range & high range and determine the correct zip Range...

I have created a query on a table: USFed2008TaxRate&Amt and created the following IIf statement expression for the field: TaxRate in that table based on the...

Hi - Please help!!!! I have created 3 queries to get to the point that I am at but still I can't get it to work to my advantage. qryTest EmployeeName ...

I have four fields in a table that contain an identifying number. I want to write a query with an expression that looks for the first field that contains a...

I have the following formula in a query. The upper spec of the dlookup is returning a 1 when it shouldn't be. Example: mindiam 10.000 maxdiamb 11.000. ...

This statement returns a syntax error, indicating I may have entered an operand without an operator: IIf(="no", "Unaltered at Intake", IIf (="spayed" And...

I'm running a query that shows sums of several fields. For one field I want to replace a null with 14. Im using the follwoing conditional statement in the...

I have one half of the result I'm looking for in a calculated field in a query. Here's the half that works: Calclo1: IIf(=True And ="Enable","Y") What I want...

I have table that lists Invoice #, Invoice $, and Invoice Date. Here is my IIF Statement: Aging Bucket:...

I have an employee database that tracks, among other things, promotion, transfer and reassignment dates. I have allowed for 9...

Hi, I would like to use the IIF statement to compare two fields in Access query design view. I would like to compare two fields in a query. I know how to...

I need to calculate multiple values for a field called CSP that will be based on a calculated field called Days. Days is calculated by using DateDifference...

The following query below works but I want the "45" part to be able to put in the query "43" Or "45" as values. How do I make the query formula...

In my query I have a field with an iif statement that is too long now. simple ex. IIf(="LA",(-)-, IIf(="NA",(-)-,(-)- )) Is there any way to convert this to...

I have a column in a SELECT query that returns a value of 1 if the record is under 5,000, zero if over 5,000 Cat0: IIf((.5000),1,0) How would I add a...

I have a query where I'm trying to rename a field if it meets certain criteria. Example: IIf(In("A", "B", "C"), "Atlanta", IIF(In("D", "E", "F"), "East",...

BothFields: IIf(="is null",,IIf(="is not null",)) What I am trying to do is If Remaining Shares are BLANK show BUYSELLSHRS If Remaining Shares are NOT...

I've written the following statement and I'm getting the following error, the expression you entered has a function containing the wrong number of...