I'm learning some basics and would really appreciate a step-by-step guide for doing something that is probably pretty elementary for many of you.
This is my table:
ID First_Name Last_Name Old_Status New_Status 1 Jane Doe 3 2 2 Jon Smith 2 2 3 Mary Jones 4 5 4 Jim Miller 3 3
I want to create a form with this table displayed as a subform in datasheet view. Then I want a button on that same form that, when clicked, selects just the records where Old_Status = New_Status and displays the results in the subform itself. I'm using Access 2007.
Thanks.