Comparing to prior record

[Guest]

Hi,

I need to compare a field in a record to another field in
the prior record. Any ideas?

Thank you for looking.

Mike

 

[Joe]

You need to create a place to store the content of the
prior record temporarily, so it is available to you when
you move to the next record. You can do this by adding a
new field to the underlying table. Go to the prior record
and copy the content from your field of interest. Then go
to the next record and paste into the field you just
created. Now you have the field value from the prior
record and the field value from the current record in two
different fields in a single record and you can run your
comparison.

 

[Allen Browne]

See:
ACC2000: Referring to a Field in the Previous Record or Next Record
at:

http://support.microsoft.com/default.aspx?scid=kb;en-us;210504&Product=acc2000

 

[Mike]

Thank you thank you!

-----Original Message-----
See:
ACC2000: Referring to a Field in the Previous Record or Next Record
at:

http://support.microsoft.com/default.aspx?scid=kb;en- us;210504&Product=acc2000

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.