Comparing fields in access 97

DeborahP · 04-28-2006, 01:23 PM

I have a database with a pre-surgery field and a post-surgery field. The use must enter the current procedure in the pre-field and then the actual surgery in the post field. I need to check to see if the fields match verbatim. The field is a memo field.

The users know how to copy and paste from the pre to the post fields. 90% of the time it is the same but not always.

Can anyone provide some help?

Thanks,
Deborah

tdt3 · 04-29-2006, 09:08 PM

In another cell use the "=IF" function to compare the two cells & show the results of the comparison, e.g.:

=IF(A1=B1,"Same", "Diff")

Chevy · 04-29-2006, 10:07 PM

If you just need them to be equal (and not report if they are not, just fix it), then an update query would do the trick.

04-28-2006, 01:23 PM	#1 (permalink)
DeborahP Registered User Join Date: May 2002 Location: South Carolina Posts: 29 OS: 2000	Comparing fields in access 97 I have a database with a pre-surgery field and a post-surgery field. The use must enter the current procedure in the pre-field and then the actual surgery in the post field. I need to check to see if the fields match verbatim. The field is a memo field. The users know how to copy and paste from the pre to the post fields. 90% of the time it is the same but not always. Can anyone provide some help? Thanks, Deborah

04-29-2006, 09:08 PM	#2 (permalink)
tdt3 Registered User Join Date: Oct 2005 Posts: 8 OS: Win XP Pro	In another cell use the "=IF" function to compare the two cells & show the results of the comparison, e.g.: =IF(A1=B1,"Same", "Diff")

04-29-2006, 10:07 PM	#3 (permalink)
Chevy Retired Join Date: Jul 2003 Location: Notlob Posts: 5,452 OS: Vista Ultimate My System	If you just need them to be equal (and not report if they are not, just fix it), then an update query would do the trick.