iif statement

Hi all, I know access is not the best at formulas, but I have certain customer names were they can have the name entered slightly differently ( like Microsoft, Microsoft Inc, Microsoft UK).. Is there a iif contains formula so that if the customer name contains Microsoft then return the word...

Hello All, I am creating a query with several fields that are calculated off of other fields in a table. I currently have 4 set up in the same query, two are working and two are not. These IIf statments are basically looking at other fields to see if conditions apply then inputting a response...

https://uploadfiles.io/glxo4 i have this file at the following link in which i want to apply iif function in a way that if S1 = Operation(S1) then give me value from total otherwise remain blank IIF S2 = S2(operation) then give me value from the same row of the total column otherwise remain blank

Hi All, I am having some trouble trying to create a query that will return a default value if the date being looked up falls between any of the start and end times in another table. The date being looked up is in table1 and start and end dates are in table2. I need for the value in table 1 to...

Hello, What I want is for when a number in the column passes a value that I have set, a message will be sent to me. The code that I have to send me a message is working its just not reading the values that I have in my columns correctly and sending me to many messages even when I have nothing...

Good Morning, I've built a query in Access and am have a data type mismatch in an IIF statement. I know where the problem is but I don't know how to fix. Last night, two of us worked on for 4 hours. Ugh! When I use each part of the IIF statement separately, they work. I cannot put them...

Hi! I am trying to figure out how to write a formula in a query where it searches two fields in an IIF statement. I tried... Current and Future Territory?: IIF([Remove Account From] Is Null And IIf([Effective Billing Month/Year (Oct FY11 =...