Microsoft Access 2007: Using an IF statement

5 pts.
Tags:
Database programming
IF statement
Microsoft Access
Microsoft Access 2007
VBA
I want compare a field in one record to the same field but in the next record. For example I have this IIF statement: IIf(([MAILADDRESS]=[MAILADDRESS]),True,False) This will compare the MAILADDRESS in the same record but I want to compare that same field but in the following record. How do i do that? Something like if MAILADDRESS = MAILADDRES + 1 type of thing but obviously putting a plus 1 in there doesn't seem to work. Thanks for your help! I don't know if your answers get emailed to me automatically since first time using this site. If not, could you send answer to servent1@msn.com? thanks! Dean

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: