Cell Reference in Access?

[chrisobrien1027]

Hi, I am trying to do something similar to cell referencing in Excel with Access.

For example, in Excel, one of the formulas I have is:
=if(E3=E2,0,1)
=if(E4=E3,0,1)
=if(E5=E4,0,1)

and so on...

I want to do something similar in Access without using excel and I've heard that it can be done using Forms but I have no idea where to begin. Any help would be greatly appreciated...

CO

 

[Mike375]

=if(E3=E2,0,1) becomes

=IIF([E3]=[E2],0,1) Note the two Is

You would put that in an unbound text box.

You can also use it to make a new (calculated) field in a query

YourNewFieldName:IIF([E3]=[E2],0,1) Note the two Is

 

[Luddite Lad]

Access does not use cell references, so whilst Mikes formula is valid, it is some what meaningless.

You might want to do some reading on the differences between Excel and Access, and also read up on normalisation.