I want compare a field in one record to the same field but in the next record.
For example I have this IIF statement:
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
December 11, 2008 1:00 AM
December 11, 2008 4:22 PM