View Single Post
  #1  
Old September 28th, 2004, 05:46 PM
rleblanc
external usenet poster
 
Posts: n/a
Default "Between" "and" parameters access. How?

I have several reports which ask for a "Start Date" and an "End Date" for
use in determining the period of time the report is to show data for. For
this I use the "Between" and "and" function to request from the user what
period of time to display data for.

However, I would like to be able to show at the top of the report the period
covered by the report such as:

Report for start date: mm/dd/yyyy to: mm/dd/yyyy

How do I access the "Start Date" and "End Date" which were entered as part
of a select query? Does Access have a special name for these values? How can
these parameters be accessed for use in the report?

Thanks