I have a table that is for orders which contains a field - Salesperson & a field Salesperson2. Right now I'm able to search and print a report that subtotals by salesperson. I just added salesperson2 for sales where 2 salespeople work on and both get commission. I'm looking to search all orders for a sales person (whether listed they are listed as salesperson or salepserson2). I know that I can search salesperson then salesperson2 but was looking for a way to search with one field (ie SalespersonAll that looks at both salesperson & salesperson2). My next hurtle is how to subtotal the report so it groups all orders. Other than searching salesperson- running the report then searching salesperson2 - running the report then adding them together.....I'm stuck. Any thoughts or directions would be appreciated!