date range-report

  • Thread starter Thread starter patro
  • Start date Start date
P

patro

Guest
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]

HTH
 

Users who are viewing this thread

Back
Top Bottom