IIF statement to compare two fields.

  • Thread starter Thread starter E-mail report using Lotus Notes rather t
  • Start date Start date
E

E-mail report using Lotus Notes rather t

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
do it in Access using IF statement (i.e. IF(A1=A2, "Yes","No"). Please tell
me how to write an IIF statement in Access to compare two fields. Thank you.

Regards.
 
In design view in Field row blank use this with your actual field names --
My_IIF_Results: IIF([Field1] = [Field2], "Yes", "No")
 
CompareFields: IIf([Field1]=[Field2],"Yes","No")

However you have to watch out for nulls.

Debug.Print IIf(Null = Null,"Yes","No") will return No even though they are
both nulls.
 
Hi, I have a question in regards to IIF statement,
I want to serach within the same colmun for records that starts with "SHS" or "SCS" when found, then divide the balance field by 200
Then search for records that starts by "s260" or "SSPC" and divide the balance field by 170.
Could anyone help me?
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Iif Statment 7
joining two iif statements 2
IIF "and" statement 2
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Weird Query Possibility 1
IIF Statement in Query 2
Mutiple IIF Statements 4
IIF Statement 2

Back
Top