I'm generating a report that needs to have the ability to sort by customer name within a specific date range that can be changed i.e.(4/6/01-6/2/01) Your help would be greatly appreciated, thanks
I am assuming <--(Bad Word) that you are using a query for your report source I am also assuming that you are using a form to get the date values.
If this is the case then in the field that holds the date type the following in the criteria line
=Between([Forms]![Form Nmae]![Date Field Start] and ([Forms]![Form Name]![Date Field End]