Help with parameter query

  • Thread starter Thread starter Zeunasc
  • Start date Start date
Z

Zeunasc

I have a very simple query that has two parameters - [Enter Start
Date] and [Enter End Date].

The End Date should always be 90 days from the Start Date. I would
like to just have the [Enter Start Date] parameter and have Access
calculate the end date, but I have know knowledge of how to do this.

Any ideas?

TIA,
Tim
 
Change the criteria in the query to:

Between CDate([Enter Start Date]) And (CDate([Enter Start Date]) + 90)
I have a very simple query that has two parameters - [Enter Start
Date] and [Enter End Date].

The End Date should always be 90 days from the Start Date. I would
like to just have the [Enter Start Date] parameter and have Access
calculate the end date, but I have know knowledge of how to do this.

Any ideas?

TIA,
Tim
Click to expand...
 
Back
Top