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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Post your SQL statement. Open the query in design view, click on menu VIEW
- SQL View. Hightlight, copy, and paste in a post.
 
Back
Top