patro
09-06-2001, 04:58 PM
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
|
View Full Version : date range-report patro 09-06-2001, 04:58 PM 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 Dave Sherer 09-09-2001, 07:51 AM 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] HTH |