I have a report layout done, and it does bring information from the server, however I am trying to display a Customer(s) sales orders based on the rep at the time based on a date range. It only displays the current sales rep set to default on the database. For example I have Customer "A" that that was being represented by rep "1" from 2007 to 2008. Rep "2" was assigned in 2009 for this Customer. When I run my report from a daterange since 2007, it displays Rep "2" since 2007 since it's not true since it was assigned in 2009. Any direction would be helpfull.

 

Thanks in Advance

 

Jessie