MS Access Query

[vinwin06]

Hi All,

Can any one help me in creating query in MS access for the below formula;

=IF(A2=A3,0,1)

Example:
The query has to match the first and second record if it matches then it will update as "0" in a new column.


Can anyone tell how i can do that?

Thanks in advance.


Regards,

Vinoth

 

[MSAccessRookie]

IF is not the right function to use here. Try looking up the IIf() function instead. You already have the necessary infomation, and I believe that the IIf() function will give you what you are looking for.

Hi All,

Can any one help me in creating query in MS access for the below formula;

=IF(A2=A3,0,1)

Example:
The query has to match the first and second record if it matches then it will update as "0" in a new column.


Can anyone tell how i can do that?

Thanks in advance.


Regards,

Vinoth

 

[vinwin06]

Actually i have mentioned that IF function in excel. how we can execute in Access. Moreover how you will find out the difference between two values in access. That s my question?