How do you compare a current record to the next record or compare a current record to the previous record in a access query? I would like to look through a list and anything that has the same account number would be compare to one another??
