If then Statements for a newbie

[Pjameson]

Hi, I'm new to Access and I have to figure out how to handle an issue I'm having at work. I'm trying to format Access to autofill some data for me if certain situations apply. I will attach a pic below, but the basic principle is that IF both Serial No Top and Serial No Bottom in row 3 EQUALS the Serial No Top and Serial No Bottom from the row above THEN the Number of Cuts in row 3 will be autofilled with the Total Cuts number from the row above. This is to prevent our employees from distorting data for our system of blade tracking. I hope that makes some sense. Just asking because I have no idea or if it's even possible. Thanks.

[June7]

It's possible, can be tricky. Review:
http://allenbrowne.com/ser-24.html
http://support.microsoft.com/kb/210236
http://support.microsoft.com/kb/210504

It's also possible to retrieve the value of the previous record by query whenever needed for display on report, and not have to save to field in table, again, also very tricky.

[Pjameson]

It's possible, can be tricky. Review:
http://allenbrowne.com/ser-24.html
http://support.microsoft.com/kb/210236
http://support.microsoft.com/kb/210504

It's also possible to retrieve the value of the previous record by query whenever needed for display on report, and not have to save to field in table, again, also very tricky.

Let me check those out. I was assuming that it would be no easy task, but the more I try, the more familiar with it I will get. Thanks.

[dreday]

You can use the after update event as well on the 2nd number, so when you move on from that field it can check the 2 fields from the record before.