This is in ACCESS. I'm just not sure what formulas to use! I know you don't have access to the exact table. Thanks!

Create a query (qryRichmondChesterActive) to display all matching records from tblMember table, selecting the MemberID, FirstName, LastName, and JoinDate fields in which the City field value is Richmond or Chester AND the MembershipStatus is Active. Save and run the query. (Ref: lab3/The And/Or Logical Operators)