I have two fields, one shows is "?1261.01" and the other is a total field "?4651.19". I want to show this as a percentage on a summary report. So I did a calculated field which did ?1261.01 / ?4651....
No problem. Make al SalesRep Table with the Key field being a User field. When you make the a relationship all the Sales will automatically attach to the correct Sales Rep.