query for top order for each member of group within given time fra

[Guest]

Hello,

I am trying to write a top value query that will allow me to see the top
order for each sales rep within a given region for a specified time period.
I am having trouble with the query in trying the specify the time period
constraints. If I use Between [start date] and [end date] my query does not
return any values; however if I do not have any time constraints it is
looking at 6 years of data. I have tried writing multiple queries but I can
not seem to get any of them to work. Any suggestions or ideas are greatly
appreciated.

Best Regards,
Rebekah

 

[Guest]

Post your SQL statement. Open the query in design view, click on menu VIEW
- SQL View. Hightlight, copy, and paste in a post.